Create a histogram using ms excel


Discussion:

Q1: Using Equations
Word-process the following five equations:

k= N/n

z= (x ¯-μ)/(σ/√n)

z=(x ¯-μ)/(σ/√n √((N-n)/(N-1)))

p ^=x/n

z=(p ^-p)/√((p·q)/n)

Using Drawing Tool to Create Diagrams

Suppose in a large department store, the average number of shoppers is 448, with a standard deviation of 21 shoppers. We are interested in the probability that a random sample of 49 different shoppers will yield a sample mean between 441 and 446 shoppers. Create and attach a normal curve to this document with the following elements: the normal curve, a label of the average number of shoppers, and labels for the sample means of 441 and 446 shoppers. Include all the appropriate symbols.

Q2: Descriptive Statistics
The monthly average low temperatures* during different months of year at Manchester, NH are given below:

January February March April May June
5 8 18 29 40 50

July August September October November December
55 53 44 32 24 12

a) Find the mean yearly low temperature based on the monthly averages by applying the formulas (without using computer software).

b) Find the standard deviation of the monthly low temperatures by applying the formulas (without using computer software).

c) If the above data was a sample, what would be the sample standard deviation? Compute by applying the formulas (without using computer software).

d) Use functions in Excel to compute the mean, population standard deviation and sample standard deviation.

e) Create a histogram using MS Excel. Comment on the distribution of monthly low temperatures. Copy and paste your spreadsheet work into this Word document. Hint: use 9, 19, 29, 39, 49 for the bins.

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Create a histogram using ms excel
Reference No:- TGS01898531

Now Priced at $25 (50% Discount)

Recommended (99%)

Rated (4.3/5)