There are two questions 1 Using Excel or any statistical sof

There are two questions:

1. Using Excel or any statistical software , Find the Mean, Median, Mode, Quartiles, Variance, Standard Deviation for the following numbers.

8,12,16,17,22,34,26,10,34,22,6,23,38,44,19.

2.The marketing manager of a large supermarket chain would like to determine the effect of shelf space on the sales of pet food. A random sample of 5 equal-sized stores was selected and the results are presented below: (=.01)

Store       Shelf Space (feet)       Weekly Sales ($100)

_____________      X_______________ Y_________

1            8            16                  x = 36,                x2 = 274,            n = 5

2            9            22

3            7            14                  y = 95                 y2 = 1995            xy = 708

4            4            15

5            8            28   

a) Predict the average weekly sales of pet food for stores with 50 feet of shelf space for pet food.    

b) Compute coefficient of correlation.                                             

c) Compute standard error of estimate.                                             

d) Setup 95% confidence interval for population mean (assuming X=20).              

e) Is there any correlation between X & Y

Solution

1)Arrangina all the data in the ascending order

6,8,10,12,16,17,19,22,22,23,26,34,34,38,44

a)MEAN =Sum of all data/total sample =(6+8+10+12+16+17+19+22+22+23+26+34+34+38+44)/15 =22.066

b)Median is the middle value =>22

c)Mode is the data that occur maximum time .From the figure the mode is 22,34

d)Quartile 1st quartile =(n+1)/4 th observation =(15+1)/4 =4th observation =12

3rd quartile =(3(n+1))/4 observation =12th observation =34

e)The standard deviation on calculation is 11.37