Please answer these questions on excel and show process step by step

lti EA FEEDS": ii'i' *EE |F w] HW Set iii-Review (15 probs)i1)2 [iaiti AaBchD AaBb( AaBchD AaBchDdEe tail: 6 r lam an 1 Iliiaa an i b. What is the expected number of service calls per day in this re department\"? a ' Hw #1 - Review Problems H ' Note: Please read the HW Guidelines under the \"Course information\" link on BB, 61 Consider the example of ipping a coin two times 3 To" you attempt to \"I" \"'9" m ' a. List all possible outcomes of this experiment, e _ _ _ h. Assume we are Interested in the number at heads facing up after the ipping the 2 1. A student organization is Interested to nd the percentage of the students that 2 coin twice. What is the random variable of interest? I smoke, in a local university. A random sample of size 100 students (N=12000) were a o. Is the random Variable of Interest discrete or continuous? I selected. The respondents were asked whether they smoke? 30 responded yes and a d' Show the probability distribution of this random variable J the rest said no. , : at Specify the population. 2 : b'wgatis '29 palrameter oftlhls population; ' bl 7 7. It is known that the average weekly rate of US production worker is $600 Assume : ' 8" i\" a '9 \"\"55\"\" 9 sun's\" "\" '5 pm "' ' that the distribution of wage is normal with a standard deviation of $100. , d. What is the best estimate of the percentage of students that smoke? 2 a. What is the median weekly wage rate? 1 3' How ca" the student organization improve the answerto part d 7 ' i b. What is the probability that a production worker earn between $500 and $800? 2 ' , , , y , , , l c. What is the probability that a production worker earn more than $800? 2 2' Idem'fy the '"'\"'"9 variables as qualitative ' quantitative. ' d. What percent of production workers earn more than $1000 per week? 2 a. Gender 1" 35'3\" ' Class designation '1' Education level ' i e. What Is the probability that a sample of size 50 workers has an average weekly e. Sales 6. Temperature 9. Make oia car h. Height 2 salary of more than $700, , 1. Season of the year i. Advertising expenditure e i : l k. Type of advertising I. Store location 2 i : r I . . . . i 8. Assuming that the price 0! gas per gallon in a city is normally distributed with a mean , 3' \"5'"; the data belgw, answer theliollowmg questions usmg a table format, ' ' of $1 30 and a standard deviation of 5010, answer the following questions: , I 5 2 1 4 a. What percent oi gas stations charge within 1 10. 20, and 30 around the mean? 2 ,y" ' ' ' ' ' . ' i b. Find two prices symmetrically around the mean in which 90% of gas stations charge a. r, b. y' c. x.y, d. Showttlat x, . y, = X), , r within those Momma: 12a: E: E izal1 E E i c. Find two prices symmetrically around the mean in which 95% of gas stations charge 2 within those two prices. .v 4 4 4 1 4 4 1 ' cl. Find two prices symmetrically around the mean In which 99% of gas stations charge e 2x3 f. ny g. [2:91,] It. Showthat z(2x,] : i within those two prices, a H H H H H e. What is the probability a gas station selected at random charge more than $2.50. a i . _ . _ i : 1' Show that E0" x) = 12-90;. y) = 0 J , 9. A bottling company sets a machine to ll 12 ounces ola soft drink in every bottle. A , , 1 State inspector. in looking out for customers. selects a random sample of 49 bottles , 4_ The grades are student in ve subjects are: 55' 92' 81. my 92_ , i once a week. If the mean ofthe sample is less than 1138 ounces, the company is a l a. Find the mean grade. .1 given a $1000 tine. Assume that the population standard deviation is 0.07 ounces. 2 b' Find the range ofgrade. , a. Find the mean and standard deviation of the distribution of the mean of the samples c. Find the variance and standard deviation using the computational formula. , SSISC'Bd by "'9 INSPBGiOF- 1 _ d. Find the variance and standard deviation using the d nitional iormuia. : b What is the shape at the distribution of Xt Explain. a e. Are the answers in parts \"c" and \"d' equal? Verify using Excel's \"m'feature. : c. Find the probability that the mean of an inspector's sample is less than 1138 6. Are the answers in parts \"c\" and "d' equal? Verify using \"descriptive statistics\" 0\""395- , leature 0' Excel. e t in t e pro a l I t at a ott e se ecte at ran orn as ess t an . ounces o dF'dh bb'l' h bl | d d h l h 1198 f 9. Circle the value of standard deviation obtained in pans 'c\El HW Set #1-Review (15 probs)(1)2 [asses] il A ii'l' *EE EIFH RIM: 359%] AaBchD AaBb( AaBchD AaBchDdEe lm if? \"1%! EW a. What is the standard deviation of the distribution of 7:. it many samples of size 64 is selected. , b. What is the probability that a random sample of 64 students will provide a sample mean SAT score within 10 points ofthe population mean? : 11. A New York restaurant would like to estimate the average amount customers spend for dinner. A sample of size 49 customers resulted an average of $32.60. Assume the population standard deviation is 35. ; What is the point estimation for the mean of the population? a At 90% level of condence. what is the margin of error? : What is the 90% condence level for the mean ofthe population? : you???" . A car rental company is interested to estimate the average miles its cars are driven 2 in a particular holiday. A sample of 200 cars is selected from its eet of 25000 cars. : The mean and standard deviation of the sample are 54.50 and 14 miles, : respectively, , 3. Develop a 95% condence Interval for the average miles driven. a h. In another region 200 cars were rented and $2500 of fees was collected. Given that 25 cents are charged per miles driven, is there any reason to investigate the billing practices in the other region? Support your answer using the condence interval in part "a'. Support your answer using statistical reasoning and logic. : 13. A sample of B senior citizens indicate the following prescription oust in dollar for , Zocor (a drug used to lower the cholesterol): : 98 104 126 110 112 115 100 99 .v a. What is the point estimate for the population mean of the prescription cost of Zocor? a b. Assuming that the distribution of Zocor prescription cost is normally distributed. nd 95% condence interval estimate of population mean prescription cost of Zocor? a 14. A Cell Phone company sells cellular phones and airtime In a State. At a recent 1 meeting, the marketing manager states that the average age of the customers is 40 = years. Before actually completing the advertising plan, it was decided to select a , random sample of customers. Among the questions asked in the survey of 50 : customers wasthe customer's ages. The mean and the standard deviation ofthe , data based on the survey are 35 years and 7 years. : . Formulate a hypothesis to test the marketing manager's claimt , . Does the sample support manager's claim. Test at 0.05 level of signicance. a crro 15. A manufacturer claims that one of its new cars having a highway fuel efciency : average of 30 miles per gallon (MPG). A consumer interest group would like to test , whether there Is any statistical evidence that the manufacturer Is over stating the 1 MPG. A sample of 25 cars of this brand resulted In a sample mean highway mileage = rating of 29.5 MPG and a standard deviation of 1.8 MPG. : a. State the null and alternative hypotheses needed to conduct this test? : b. What test statistic should be used and why? Should any assumption be made about the distribution of MPG? : c What conclusion can be drawn from the sample results? Test at o=D.05t = sauna 1275'|\\$ I13