McGraw-Hill Connect Math Previous 21122-23, 2426 27, 28 29 30 Next Question 25 o

Question

McGraw-Hill Connect Math Previous 21122-23, 2426 27, 28 29 30 Next Question 25 of 35 (1 point) 3.2 Section Exercise 37ab (calc) Stock prices: Following are the closing prices for a certain stock during June and July of a certain year June July 488.50 483.19 497.99 488.56 486.25450.20 456.56 467.49 475.83 489.20 482.05 472.68 472.08 454.26 444.95 491.34 494.02 459.61 466.18 481.59 482.37 493.37 498.72 485.52 484.78 477.50 484.81 490.06 488.97 492.63 A. a. Find the population standard deviation and variance for the prices in June. Round the answers to three decimal places. The population standard deviation for the prices in June is The population variance for the prices in June is b. Find the population standard deviation and variance for the prices in July. Round the answers to three decimal places The population standard deviation for the prices in July is The population variance for the prices in July is

Explanation / Answer

Solution:

We us excel for all calculations

a) For June data set,

Population standard deviation= ---------?

Using excel, =STDEVP(A2:A16)

Population standard deviation= 14.382

Population variance = --------?

Using excel, =VARP(A2:A16)

Population variance = 206.837

b)

For July data set,

Population standard deviation= ---------?

Using excel, =STDEVP(B2:B16)

Population standard deviation= 13.962

Population variance = --------?

Using excel, =VARP(B2:B16)

Population variance = 194.926

Done

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---