Question
In: Statistics and Probability
An electronics company is looking to develop a regression model to predict the number of units...
An electronics company is looking to develop a regression model
to predict the number of units sold for a special running watch.
Data is provided below:
| Sales (units) | Price ($) | Advertising ($) | Holiday |
| 500 | 100 | 50 | Yes |
| 480 | 120 | 40 | Yes |
| 485 | 110 | 45 | No |
| 510 | 103 | 55 | Yes |
| 490 | 108 | 40 | No |
| 488 | 109 | 30 | No |
| 496 | 106 | 45 | Yes |
Compile a spreadsheet for the data and determine the predicted number of units sold if the watch is sold on a holiday for $200 while $150 is spent on advertising.
|
370 |
||
|
420 |
||
|
424 |
||
|
860 |
Solutions
orchestra answered 2 years agoRelated Solutions
An electronics company is looking to develop a regression model to predict the number of units...
An electronics company is looking to develop a regression model
to predict the number of units sold for a special running watch.
Data is provided below: Sales (units) Price ($) Advertising ($)
Holiday 500 100 50 Yes 480 120 40 Yes 485 110 45 No 510 103 55 Yes
490 108 40 No 488 109 30 No 496 106 45 Yes Compile an excel
spreadsheet for the above data and determine the regression
equation Answer (a) X3 = 1 if...
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital
Database to predict the number of Personnel by the number of
Births. How many residuals are within 1 standard error? Write your
answer as a whole number.
Personnel
Births
792
312
1762
1077
2310
1027
328
355
181
168
1077
3810
742
735
131
1
1594
1733
233
257
241
169
203
430
325
0
676
2049
347
211
79
16
505
2648
1543
2450
755
1465
959
0
325...
Use Excel to develop a regression model for the Hospital Database to predict the number of...
Use Excel to develop a regression model for the Hospital
Database to predict the number of Personnel by the number of
Births. How many residuals are within 1 standard error? Write your
answer as a whole number.
Personnel(y)
Births(x)
792
312
1762
1077
2310
1027
328
355
181
168
1077
3810
742
735
131
1
1594
1733
233
257
241
169
203
430
325
0
676
2049
347
211
79
16
505
2648
1543
2450
755
1465
959
0
325...
Use Excel to develop a multiple regression model to predict Cost of Materials by Number of...
Use Excel to develop a multiple regression model to predict Cost
of Materials by Number of Employees, New Capital Expenditures,
Value Added by Manufacture, and End-of-Year Inventories.
Locate the observed value that is in Industrial Group 12 and has
7 employees. Based on the model and the multiple regression output,
what is the corresponding residual of this observation? Write your
answer as a number, round to 2 decimal places.
SIC Code
No. Emp.
No. Prod. Wkrs.
Value Added by Mfg....
A university would like to develop a regression model to predict the point differential for games...
A university would like to develop a regression model to predict
the point differential for games played by its men's basketball
team. A point differential is the difference between the final
points scored by two competing teams. A positive differential is a
win for the university's team and a negative differential is a
loss. For a random sample of games, the point differential (y) was
calculated, along with the number of assists (x1), rebounds (x2),
turnovers (x3) and personal fouls...
A business statistics professor at a college would like to develop a regression model to predict...
A business statistics professor at a college would like to
develop a regression model to predict the final exam scores for
students based on their current GPAs, the number of hours they
studied for the exam, the number of times they were absent during
the semester, and their genders. Use the accompanying data to
complete parts a through c below.
Score GPA Hours
Absences Gender
68 2.55 3.00 0
0
69 2.22 4.00 3
0
70 2.60 2.50 1
0...
Develop the best logistic regression model that can predict the wage by using the combination of...
Develop the best logistic regression model that can predict the
wage by using the
combination of any following variables: total unit (X2),
constructed unit (X3), equipment
used (X4), city location (X5) and total cost of a project (X6).
Make sure that you partition
your data with 60% training test, 40% validation test, and default
seed of 12345 before
running the logistic regression (15 points)
Wage - X1
Total Unit - X2
Contracted Units - X3
Equipment Used - X4
City...
Use the following data to develop a multiple regression model to predict from and . Discuss...
Use the following data to develop a multiple regression model to
predict from and . Discuss the output, including comments about the
overall strength of the model, the significance of the regression
coefficients, and other indicators of model fit. y x1 x2 198 29
1.64 214 71 2.81 211 54 2.22 219 73 2.70 184 67 1.57 167 32 1.63
201 47 1.99 204 43 2.14 190 60 2.04 222 32 2.93 197 34 2.15
Appendix A Statistical Tables *(Round...
Develop a simple linear regression model to predict the price of a house based upon...
Develop a simple linear regression model to predict the price of a
house based upon the living area (square feet) using a 95% level of
confidence.
Write the reqression equation
Discuss the statistical significance of the model as a whole using
the appropriate regression statistic at a 95% level of
confidence.
Discuss the statistical significance of the coefficient for the
independent variable using the appropriate regression statistic at
a 95% level of confidence.
Interpret the...
Develop a simple linear regression model to predict a person’s income (INCOME) based on their age...
Develop a simple linear regression model to predict a person’s
income (INCOME) based on their age (AGE) using a 95% level of
confidence.
a. Write the regression equation.
Discuss the statistical significance of the model as whole
using the appropriate regression statistic at a 95% level of
confidence.
Discuss the statistical significance of the coefficient for the
independent variable using the appropriate regression statistic at
a 95% level of confidence.
Interpret the coefficient for the independent variable.
What percentage of...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- The correlation between X and Y ______________. Question options: measures the variation around the predicted regression...
- Will iron(III) hydroxide precipitate from a pH = 1.00 solution with [Fe3+] = 1.0 x 10-5?...
- What do you believe happens during the final scene of the story between the brothers at....
- A 5.171 g sample of a solid, weak, monoprotic acid is used to make a 100.0...
- 1. Creep is one of deformation that occurred in concrete structure. Give one example that can...
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
ADVERTISEMENT