Question

Suppose that you are a member of this arbitration panel. Construct a 95% confidence interval for the true mean return of the investor's portfolio. Record your answers below. Input the lower bound of your confidence interval.

Answer 1

Answer:      Margin of Error = 1.944

                    Lower Bound = 3.052

Explanation:-

Attached below is a file for monthly Rate of return. Used an excel sheet to determine the confidence interval which seems relatively easier as compared to manual computation. The range below (A2:A40) shows the monthly

Functions used : Standard Deviation as= STDEV (A2:A40)

                             Sample Mean = AVERAGE(A2:A40)

                             Margin of Error = CONFIDENCE.T(D4,D5,D2)

                              Lower Bound Interval = D6-D7 = -3.052