Overview
1. You’re the owner of a PopStroke mini golf franchise. You would like to be able to
predict the number of customers you’ll get each day so you can be adequately staffed. Based on your experience, you believe that the temperature outside has a relationship with the number of customers at your business. Create a data set (n=10) with one column for the number of customers and another column for the average daily temperature. You can make up the numbers or use ChatGPT or another program to generate a data set for you. You do not need to include your data set in this document. Run a simple linear regression in Excel and insert a screenshot below. If you do not include the screenshot of your analysis you will receive a zero on the entire assignment. (2 pts.) 2. What is the dependent variable? (1pt.) What is the independent variable? (1 pt.) 3. Is this a statistically useful model? (Just state “yes” or “no”) (1 pt.) 4. What is the y-intercept? (Just enter the coefficient, do not elaborate) (1 pt.)
5. Can the y-intercept be practically interpreted? (Just state “yes” or “no”) (1 pt.) 6. What is the slope? (Just enter the coefficient, don’t elaborate) (1 pt.) 7. What is the R2? (Just report the value, don’t elaborate) (1 pt.) 8. Interpret the R2. (State this as shown in the lecture slides). (1 pt.)