Background A small independent organic food store offers a variety of specialty coffees. To determine whether price has an impact on sales, the managers kept track of how many kilograms of each variety of coffee were sold last month. The data and summary statistics are shown below. Data and Summary Statistics Price Per Kilogram Kilograms Sold $3.99 75 $5.99 60 $7.00 65 $12.00 45 $4.50 80 $7.50 70 $15.00 25 $10.00 35 $12.50 40 $8.99 50 Mean $8.75 54.40 Standard Deviation $3.63 18.33 Correlation -0.927 PROMPT Please clearly answer the following questions in a word file and then submit both the word file (a PDF file is fine too) and the excel file. 1. Please draw a scatterplot. (3pt) 2. Use the provided statistics summary to estimate the linear regression model that relates the response variable (monthly sales) to the predictor variable (price per kilogram). (5 pts) 3. Please copy and paste the provided data into an excel file and run the regression using a level of significance of 0.05. (5 pts) 4. Please find the t-stat and the corresponding p-value and explain their meanings. (3 pts) 5. Please find the F value and the corresponding p-value and explain their meanings. (3 pts) 6. Find the value of R2. Interpret its meaning in this context. (3 pts) 7. Using the estimated regression equation to estimate the monthly sales for a variety of coffee that costs $12.00 per kilogram. (3 pts)