Question Solved1 Answer Question 5 (12 pts) The number of television viewing hours per household and the prime viewing times are two factors that affect television advertising income. A random sample of 25 households in a partic- ular viewing area produced the following estimates of viewing hours per household 3.0, 6.0, 7.5, 15.0, 12.0, 6.5, 8.0, 4.0, 5.5, 6.0 5.0 12.0, 1.0, 3.5, 3.0, 7.5, 5.0, 100, 8.0, 3.5, 9.0, 2.0, 6.5, 1.0, 5.0 1 a. Scan the data and use the range to find an approximate value for s. b. Calculate the sample mean i and the sample standard deviation s. Compare s with the approximate value obtained in part a, c. Find the percentage of the viewing hours per household that falls into the interval : +2s. Compare with the corresponding percentage given by the Empirical Rule (assuming data is relatively mound-shaped).

A F B с D E USA Annual Purchases Report 2011 1 City Education Annula Purchases Annual Salary ΣΙΣΣΙ Customer ID Gender 2 3 C11 M 4 C12 M 5 C13 6 C14 M 7C15 F 8 C16 F 9 C17 F 10 C18 F 11 C19 M 12 C20 f 13 New York University New York High School Seattle University Chicago University New York University Chicago University Seattle High School Seattle None Seattle University New York None 6233 4233 6560 5001 7034 5345 790 240 4300 232 7500 4999 6750 12000 17500 13150 3799 2150 22450 2500 14 Total Annual Purchases Annual Salary Gender Male Female City 15 16 New York 17 Chicago 18 Seattle 19 City New York Chicago Seattle Education Average Annual Purchases 20 Gender Male Female 21 University 22 High school 23 None 24 25 Gender 26 Male 27 Female Annual Purchases City New York Chicago Seattle Population The photo is a part of database, so the questions are answered by using functions and formulas. [1] Open a new workbook and create the above worksheet. [2] Format on Alignment, Shedding, Borders, Wrap text, Orientation. [3] Format Colum E and D to Currency with dollar sign and two decimal places. [4] Find the Total Annual Purchases for each City. [5] Find the Average Annual Purchases for each Education. [6] Find the total number of customers from each gen [7] Find the total annual salary for each gender in each city. [8] Create the below Charts in the same worksheet. Annual Phurchases Total Annual Purchases Seattle $11,890.00 $8,000.00 $7,000.00 $6,000.00 $5,000.00 $4,000.00 $3,000.00 $2,000.00 $1,000.00 $0.00 M Female Male Chicago $10,346.00 New York Chicago Seattle New York $17,732.00 Chicago Seattle Male New York $5,155.67 $7,034.00 $4,300.00 $0.00 $5,000.00 $10,000.00 $15,000.00 $20,000.00 $5,001.00 $5,345.00 Female $2,530.00 Anual Purchases Vs. Annual Salary Population $30,000 $25,000 $20,000 $15,000 40% $10,000 Male $5,000 Female . $0 60% C11 C12 C13 C14 C15 C16 C17 C18 C19 C20 Annual Purchases Annual Salary [9] Create the Pivot Table to count customers in regarding to their gender and education. Pivot chart is designed to visualize the result. (10 marks) [10] Create validation rule for column Gender in order to input one symbol (F or M). Create also Input Message and Error Alert. (10 marks)

4.3 The following data are the response times in seconds for n = 25 Grade 1 students to arrange three objects by size: 5.2 3.8 5.7 3.9 3.7 4.2 4.1 4.7 4.3 3.1 2.5 3.0 4.4 4.8 3.6 3.9 4.8 5.3 4.2 4.7 3.3 4.2 3.8 5.4 a. Find the mean and the standard deviation for these 25 response times. Given that { x = 454.810 (4 marks) b. Order the data from smallest to largest. (2 marks) c. Find the Z-scores for the smallest and largest response times. Is there any reason to believe that these times are unusually large or small? Explain. (4 marks)

(a) According to Eq. 8 and 9, compute the gradient of g(W) withrespect to W. Your result should be in the form of X, Y, and W. TE 9(W) = {(x?W – y.) (7) = ||XW - Y113 = (XW-Y)'(XW-Y) (8) (9)

An electric motor rotating a workshop grinding wheel at a rate of 203 rev/min is switched off. Assume constant angular decel- eration of magnitude 2.02 rad/s². Through how many revolutions does the wheel turn before it finally comes to rest? Answer in units of rev. 1. 5.00675 28.82961 3. 14.2052 4. 11.3377 5. 10.6677 6. 17.8028 7. 6.52588 8. 13.4902 9. An electric motor rotating a workshop grinding wheel at a rate of 203 rev/min is switched off. Assume constant angular decel- eration of magnitude 2.02 rad/s². Through how many revolutions does the wheel turn before it finally comes to rest? Answer in units of rev. 1. 5.00675 28.82961 3. 14.2052 4. 11.3377 5. 10.6677 6. 17.8028 7. 6.52588 8. 13.4902 9. 14.7782 10. 16.7567

d²y 2 dx y = - 8x⁹ +1 Find d²y dx || Find dx d²y 2 dx². 8x³ y=- -7x 3 d²v 2 dt² v=3t²2² +6t+ 14 Find d²v 0- 2 dt² 11 Find d²y d²y dx 2° dx y = 4x +9 11 Find dy 2 dx y= d²y 2 dx² || 1 8 d²y 2 dx y=√x Find d²y dx || Find f''(x). f(x) = 5x²-13x- f''(x) = 4 3 X Find f''(x). f(x)=x¹/7 f''(x) = Find f''(x). -2 f(x) = 7x-² f''(x) = Find f''(x). f(x) = (x² d²y 2 dx y = - 8x⁹ +1 Find d²y dx || Find dx d²y 2 dx². 8x³ y=- -7x 3 d²v 2 dt² v=3t²2² +6t+ 14 Find d²v 0- 2 dt² 11 Find d²y d²y dx 2° dx y = 4x +9 11 Find dy 2 dx y= d²y 2 dx² || 1 8 d²y 2 dx y=√x Find d²y dx || Find f''(x). f(x) = 5x²-13x- f''(x) = 4 3 X Find f''(x). f(x)=x¹/7 f''(x) = Find f''(x). -2 f(x) = 7x-² f''(x) = Find f''(x). f(x) = (x² + 5)² f''(x) = For the function y = 9x5, find d^y 4 dx 11 day 4 dx

Standing on the roof of a 96-m tall building, a girl holds her hand past the edge and throws a ball straight up at 9.2 m/s. The ball rises, then falls and strikes the ground. Considering "up" to be the positive direction, find the ball's velocity v when it is 43 m above the ground. Remember to include a "-" sign if the velocity is negative. V= m/s Record Standing on the roof of a 96-m tall building, a girl holds her hand past the edge and throws a ball straight up at 9.2 m/s. The ball rises, then falls and strikes the ground. Considering "up" to be the positive direction, find the ball's velocity v when it is 43 m above the ground. Remember to include a "-" sign if the velocity is negative. V= m/s Record your numerical answer below, assuming three significant figures.