contestada

In the "Input Analysis" section of the spreadsheet model, calculate the 95% confidence interval for the sales for each type of product. (You will not calculate a confidence interval for attendance.) Use the number of events (calculated in cell I3) as part of your calculations. (Note to Excel 2007 users: the CONFIDENCE.NORM function is not supported in Excel 2007. Use the CONFIDENCE function instead.) [5 points]

Respuesta :

danialamin

Answer:

The Formula to use is given as

[tex]=CONFIDENCE.NORM(0.05,J3,I3)[/tex] for excel 2010 and above and

[tex]=CONFIDENCE(0.05,J3,I3)[/tex] for excel 2007 and below.

Step-by-step explanation:

The formula to calculate the confidence interval is given as below

[tex]=CONFIDENCE(ALPHA,STD DEV, SIZE)[/tex]

Here

  • ALPHA is the value calculated as below

           [tex]\alpha=1-\frac{confidence\, interval\%}{100}[/tex]

  • Value of ALPHA  in this case is 0.05.
  • STD DEV is the standard deviation, which is this case is supposedly in cell J3.
  • SIZE is number of events which in this case is in cell I3.

So the formula to enter in the cell is

[tex]=CONFIDENCE.NORM(0.05,J3,I3)[/tex]

Otras preguntas