Reference no: EM13799779
.A retail store manager with Petrie Stores, Inc, wants to develop a multiple regression model to predict the amount of sales of a product per month Y from monthly advertising expenditures X1 and whether the month was December (coded 1) or another month (coded 0) X2. The multiple regression results are presented below. *will attach*
(a)Construct a scatterplot between sales (Y) and advertising expenditures (X1). See data to the right. Provide a standard evaluation of the scatterplot.
(b)Which of the explanatory variables (if any) are statistically significant (at the .05 level) in explaining product sales per month? Conduct a formal hypothesis test for each estimated regression coefficient.
(c)Give an interpretation (as applicable to the data) for each of the estimated regression coefficients.
(d)How much of the variation of y around ybar can be explained by the regression model?
(e)Conduct an F-Test (.05 level) to test for a globally statistically significant regression equation.
(f)Find the predicted sales per month when advertising expenditures equal $2,000 and the month is July.
(g)Find the predicted sales per month when advertising expenditures equal $2,000 and the month is December.
(h)Provide a brief evaluation of the estimated regression equation. Would the equation be suitable for forecasting?
2.A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year Y, and the distance (miles) X1 between home and work for the employees. A sample of 5 employees was chosen, and the following data were collected.
Distance to Work Number of Days Absent
(X1) (Y)
1 8
3 5
8 6
12 5
18 2
(a) Construct a scatterplot using Excel. Provide a standard evaluation of the scatterplot.
(b)Estimate the slope coefficient and intercept term for the regression line that relates number of absent days to distance to work by hand. Express the estimated equation in standard form.
(c) Interpret (as applicable to the data) the estimated slope coefficient and intercept term.
(d)Compute the Errors, Sum of Squared Errors (SSE), Mean Square Error (MSE) and Regression Standard Error (SE).
3.Based on the estimated regression equation in Question Two and the calculated SSE, MSE & SE, does a statistically significant (.05 level) relationship exist between the number of days absent and the distance to work? Hint: Perform a hypothesis test on the slope coefficient.
|
Developments in evolution of health care delivery
: We have spent the last five weeks reviewing the major developments in the evolution of health care delivery in the United States and analyzing the system in terms of cost, quality, access, and the provision of services. After viewing the video, ad..
|
|
The federal trade commission is an example of
: The Federal Trade Commission is an example of
|
|
Summary of hospital''s organizational structure
: Provide a detailed summary of your hospital's organizational structure. Include a tabulated description of the levels of professionals within the organization. Describe the duties of each major head within the organization.
|
|
Identify the behaviors that created this environment
: Identify the behaviors that created this environment. What behaviors would change this into a nurturing climate?
|
|
The estimated regression coefficients related issues
: Based on the estimated regression equation in Question Two and the calculated SSE, MSE & SE, does a statistically significant (.05 level) relationship exist between the number of days absent and the distance to work?
|
|
Current shipping technologies
: Come up with a list of at least 10 ideas to replace current shipping technologies (like UPS delivery trucks). Brainstorm with friends, family, or roommates.
|
|
Writing a journal on american politics
: The extra credit consists of: writing a journal on American Politics/American Public Policy's topics. The task is to read two newspaper/internet article per day, during ten days.
|
|
Functions of public relations paper
: Select an organization with which you are familiar, and identify an issue within that organization that would have both organizational and societal implications.
|
|
Mile island nuclear reactor malfunctioned
: Read the following scenario: In 1979, the Three Mile Island nuclear reactor malfunctioned, releasing radiation into the environment. There were no immediate deaths or injuries resulting from the incident; however, the accident drew much media atte..
|