Question $2$:

The dataset provided in the worksheet $($Question $2)$ includes the data for the question. The first column represents the price of a car based on its mileage, while the second column represents the mileage of a specific car. To answer the following questions, utilize the price data as the dependent variable and the mileage data as the independent variable. Use Microsoft Excel Data Analysis to analyze the data.

a$.$ Is the model statistically significant? Provide the basis for your answer. Specify the null and alternative hypotheses for this.

b$.$ Is the coefficient of the independent variable statistically significant? Provide the basis for your answer. Specify the null and alternative hypotheses for this.

c$.$ What is the coefficient of determination of the dataset? How is this value calculated $($Use an Excel formula to obtain the value$)?$ Interpret the value.

$R^2=\frac{SSR}{TSS}$ where $0R^{2}1$

d$.$ What is the estimated regression equation for the given data set?

e$.$ According to the estimated regression equation, if the mileage is $10,000,$ what is the estimated price?

Y$.$

Include all the answers for the questions in your Excel file and clearly mark your answer for each question, such as $1a,1b,$ etc., within the Excel file. Without the question number specified for your answers, your exam will not be graded.

Once your exam is ready, save the file as "Exam$4$YourName.xlsx$"($for example, "Exam$4$TomJones.xlsx$"$ if your name is Tom Jones$).$ Then, submit the exam file to the MSU Blackboard course website. Ensure that you save the file as required, avoiding any spaces or special characters, in order to avoid any possible penalties. Wrong file name will result in no grading.

Please do not copy others' work. If you copy someone else's work, it constitutes plagiarism. Similarly, if you use someone else's files and only make changes to certain parts, it is also considered plagiarism. Allowing others to copy your exam is also considered cheating, and it will be penalized equally to the person copying. While you may study together with your classmates, you must complete the exam yourself. In light of these guidelines, please include your honesty statement at the beginning of your exam file under the worksheet titled "Affidavit." Exams without this statement will not be graded.PLEASE HELP USING EXCEL FUNCTIONS!