excel file:

https://docs.google.com/spreadsheets/d/1nSkorgHyzslXAOcCFvk5m-0S8ABHl0DD/edit?usp=sharing&ouid=113068968791942309329&rtpof=true&sd=true

An analyst for an e-commerce company wants to improve their understanding of factors influencing product sales. They decide to investigate whether the price of a product affects its sales volume. The analyst selects a sample of products and collects data on their prices and corresponding monthly sales and stores them in ProductData.xlsx.

1. Conduct a hypothesis test to determine whether there is evidence of a linear relationship between the price of the product and the sales volume. Use 0.05 level of significance.
   1. State the null and alternative hypotheses.
   2. Calculate the test statistic.
   3. Calculate the p-value and critical value.
   4. Determine the statistical conclusion and communicate the results of the test within the context of the problem.
2. What other variables might explain the variation in sales volume?