Question: Since this problem is in Excel format, could I get shown how to solve it using excel with directions step by step? Thanks O claced
Since this problem is in Excel format, could I get shown how to solve it using excel with directions step by step? Thanks

O claced instructors.com Calculate Thistt. "Best Buddies international" Informati,. Topic: Discussion . Ch. 12 = Calculate... Give the gift of Master Class Ch. 11 - Calculate This! Automotive: The following table presents a portion of the annual returns for Fidelity's Select Automotive Fund (in percent). This mutual fund invests primarily in companies engaged in the manufacturing, marketing, or the sales of automobiles, trucks, specialty vehicles, parts, tires, and related services. Full Data File in Excel Format Year Automotive Fund 1987 6.54 1988 20.06 . . . 2013 46.67 Data File in Excel format for discussion 1. State the null and the alternative hypothesis in order to test whether the standard deviation is greater than 35%. 2. What assumption regarding the population is necessary to implement this step? 3. Calculate the value of the test statistics. 4. Find the p-value. 5. At a=0.05, what is your conclusion? Due Friday
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
