Question
Please complete the table below and answer the questions. The source data for the table is attached at the bottom of this submission Introduction Provide
Please complete the table below and answer the questions. The source data for the table is attached at the bottom of this submission
- Introduction
Provide the purpose of this report and an overview of its content (about 1 paragraph).
- Regression Analysis
This section presents a statistical summary of the regression analysis using the following variables:
- Dependent variable: SALES (everyone must select this variable)
- Independent variable: CALLS (everyone must select this variable)
| Use Excel OR another software package to create a scatter plot. Copy and paste the scatter plot. Make sure the dependent variable is on the Y-axis and the independent variable is on the X-axis. The axis should show the names of the variables. |
| Put the regression equation here. |
| Give the value of the coefficient of coefficient. Explain the type and strength of the correlation. |
| Give the value of the coefficient of determination. Interpret its value. |
| p-value: put the p-value Result of test: Explain whether you will reject not reject Ho. NOTE: For the hypothesis test use significance level of .05. |
| Is the regression model (regression equation) significant in predicting the dependent variable? Why? |
| |
B. What is the 99% confidence interval for the number sales estimated above. | Estimated amount sales: Put the predicted value of SALES here. I am requesting everyone to use 140 calls. However, if you already did the assignment and used a different variable, that is ok. Just put your answer here and indicate that you used a different variable. Confidence interval for estimated amount of sales: |
| Prediction interval for estimated sales: |
- Summary
Identify and describe TWO business decisions that could be made based on the results of this analysis. In other words, how might the business operations change based on these statistical results. Write one paragraph for each decision.Incorporate the results of the your findings from section 2, but do not use technical jargon - use plain business language.
Source Data
| Sales (Y) | Calls (X1) | Time (X2) | Years (X3) | Type |
| 37 | 117 | 14.8 | 0 | GROUP |
| 38 | 117 | 15.3 | 3 | NONE |
| 40 | 117 | 15.6 | 1 | NONE |
| 41 | 117 | 15.8 | 2 | GROUP |
| 37 | 120 | 18.2 | 2 | GROUP |
| 45 | 120 | 13.6 | 1 | GROUP |
| 43 | 131 | 16.8 | 4 | GROUP |
| 34 | 133 | 14.4 | 1 | GROUP |
| 37 | 133 | 15.2 | 2 | GROUP |
| 42 | 135 | 14.8 | 3 | NONE |
| 48 | 136 | 13.7 | 3 | ONLINE |
| 37 | 137 | 16.3 | 2 | GROUP |
| 39 | 138 | 15.5 | 1 | NONE |
| 45 | 138 | 19.3 | 4 | GROUP |
| 44 | 139 | 15.3 | 2 | GROUP |
| 45 | 140 | 13.6 | 1 | GROUP |
| 37 | 142 | 17.1 | 2 | NONE |
| 40 | 144 | 17.4 | 0 | NONE |
| 37 | 145 | 18 | 3 | NONE |
| 38 | 145 | 17.1 | 2 | NONE |
| 43 | 145 | 18.6 | 2 | NONE |
| 46 | 145 | 16.8 | 0 | ONLINE |
| 45 | 146 | 12 | 3 | GROUP |
| 37 | 148 | 15.7 | 3 | GROUP |
| 37 | 148 | 16.2 | 1 | GROUP |
| 42 | 148 | 16.9 | 1 | NONE |
| 43 | 148 | 15.9 | 1 | ONLINE |
| 43 | 148 | 14.5 | 4 | ONLINE |
| 44 | 148 | 13.5 | 3 | GROUP |
| 46 | 148 | 13.1 | 1 | GROUP |
| 39 | 149 | 18.8 | 1 | GROUP |
| 46 | 149 | 17.8 | 3 | NONE |
| 49 | 149 | 21.1 | 2 | GROUP |
| 40 | 150 | 10.8 | 1 | GROUP |
| 44 | 150 | 18.4 | 1 | NONE |
| 46 | 151 | 16 | 1 | GROUP |
| 37 | 152 | 19.8 | 0 | GROUP |
| 49 | 152 | 22.3 | 0 | ONLINE |
| 41 | 153 | 14.7 | 1 | GROUP |
| 42 | 153 | 15.5 | 2 | GROUP |
| 43 | 153 | 15.2 | 3 | GROUP |
| 46 | 153 | 14.1 | 1 | ONLINE |
| 42 | 154 | 14.8 | 2 | ONLINE |
| 41 | 155 | 13.6 | 3 | GROUP |
| 45 | 155 | 18.9 | 2 | GROUP |
| 39 | 156 | 13.3 | 4 | NONE |
| 48 | 156 | 15.1 | 4 | ONLINE |
| 41 | 157 | 11.5 | 3 | ONLINE |
| 47 | 157 | 14.3 | 1 | GROUP |
| 41 | 158 | 19.3 | 2 | ONLINE |
| 45 | 158 | 13.9 | 1 | ONLINE |
| 44 | 159 | 18.1 | 2 | ONLINE |
| 42 | 160 | 10.6 | 3 | NONE |
| 49 | 160 | 13.6 | 3 | GROUP |
| 49 | 161 | 16.1 | 3 | NONE |
| 46 | 162 | 16.2 | 2 | ONLINE |
| 46 | 162 | 12.1 | 1 | GROUP |
| 45 | 164 | 16.7 | 3 | NONE |
| 47 | 164 | 15.3 | 0 | ONLINE |
| 48 | 165 | 19.8 | 5 | ONLINE |
| 43 | 166 | 17.6 | 3 | ONLINE |
| 49 | 166 | 16.2 | 0 | ONLINE |
| 42 | 167 | 17.7 | 3 | ONLINE |
| 42 | 167 | 18 | 2 | NONE |
| 50 | 167 | 12.6 | 5 | ONLINE |
| 50 | 167 | 16.2 | 1 | ONLINE |
| 43 | 169 | 13.3 | 4 | NONE |
| 44 | 169 | 8.9 | 0 | ONLINE |
| 44 | 169 | 13.6 | 1 | ONLINE |
| 44 | 171 | 13.6 | 3 | GROUP |
| 48 | 171 | 13 | 2 | GROUP |
| 46 | 172 | 12.5 | 1 | ONLINE |
| 43 | 173 | 19.8 | 2 | ONLINE |
| 45 | 173 | 17.6 | 2 | ONLINE |
| 51 | 173 | 18.6 | 0 | ONLINE |
| 48 | 174 | 18.6 | 2 | GROUP |
| 57 | 174 | 10.8 | 2 | NONE |
| 48 | 175 | 13.7 | 1 | ONLINE |
| 47 | 176 | 14.1 | 2 | ONLINE |
| 45 | 177 | 14.2 | 2 | GROUP |
| 48 | 177 | 13.9 | 3 | ONLINE |
| 50 | 177 | 11.4 | 4 | NONE |
| 52 | 177 | 14.5 | 1 | ONLINE |
| 53 | 178 | 13.2 | 2 | ONLINE |
| 54 | 180 | 11.8 | 4 | GROUP |
| 44 | 182 | 15.5 | 4 | NONE |
| 53 | 182 | 10.5 | 1 | ONLINE |
| 47 | 183 | 12.8 | 2 | ONLINE |
| 49 | 184 | 16.7 | 2 | ONLINE |
| 50 | 184 | 15.6 | 2 | ONLINE |
| 53 | 184 | 15.2 | 0 | ONLINE |
| 45 | 185 | 13.3 | 1 | ONLINE |
| 44 | 188 | 12.9 | 3 | GROUP |
| 47 | 120 | 16.3 | 1 | NONE |
| 49 | 188 | 20.4 | 1 | NONE |
| 58 | 189 | 12 | 1 | ONLINE |
| 50 | 190 | 11.3 | 1 | ONLINE |
| 47 | 193 | 13.5 | 2 | ONLINE |
| 50 | 197 | 14 | 2 | ONLINE |
| 58 | 197 | 11.8 | 1 | ONLINE |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
College Algebra
Authors: Murray R Spiegel, Robert E Moyer
4th Edition
0071825851, 9780071825856
