QUESTION 06 (10 points) - Testing a Mean with Known of a Normal Population A sample of 195 cars were drawn from a population of new cars with unknown mean frice of and standard deviation of =$12,739. Those sampled cars are worth $9,370,241 in total. At the level of significance =0.08, you will need to test H0:$46,000 versus H1:>$46,000. (a) [2] Justify the test statistic you would use and make a sketch of the test. (b) [4] Carry out the test. Would you accept or reject H0. (c) [1] What is the lowest significance level to reject H0 ? What do you call that value? Sketch it. (d)[1] Based on part (c), give one example of that helps accept H0. (e) [2] Implement parts (b) through (d) in Excel. Show your Excel worksheet. Hint: Use 4 decimal places. Modify the accompanving Excel file for fal Daf............... (enter a given value) (enter a given value) (calculate it here) (calculate it here) (enter a given value) (calculate it here) (calculate it here) (use this function) (calculate it here) Y (choose a value) (use this function)