Question: Reduce the decimal spaces to three while reporting your results. Part A. Use the Excel file Used 2004 Accords and Camrys.xlsx. The file has data
Reduce the decimal spaces to three while reporting your results. Part A. Use the Excel file "Used 2004 Accords and Camrys.xlsx". The file has data for prices and other characteristics for both cars. Use the data in that file to complete the analyses needed to answer the questions below. When you have completed your analyses, submit both your written answers and your completed Excel file. The submissions are to be made through Blackboard. Q1: Using the first worksheet (Q.1 & Q.2 - Two-Sample Tests), test whether the mean prices of used 2004 Accords and Camrys are equal. Use =0.05. In conducting your test, assume that the variances for Accords and Camrys are equal. Complete the following questions. The points for each question are indicated in the parenthesis. a. What is the hypothesis you will test? Provide a complete mathematical expression of the hypothesis statement. (2 points) b. Calculate (using Excel functions) the means and variances for Used 2004 Accords and Used 2004 Camrys. Report the values
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
