Multiple regression results

Assignment Help Engineering Mathematics
Reference no: EM13822623

1. 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.

Reference no: EM13822623

Questions Cloud

What were the critical drivers of starbucks success : In the early 1980s, how did Howard Schultz view the possibilities for the specialty coffee market? Why did Schultz think he could successfully import the Italian coffee bar concept to the United States? Was Schultz's strategy a blue ocean strategy? A..
What is the connection between galton''s beliefs : What is the connection between Galton's beliefs about intelligence and (a) eugenics, and (b) mental testing? must be 300 words and able to pass through turn it in
Write paper about christianity communication and connections : Write paper about Christianity, Communication and Connections.
What is plato idea about the best type of life : Describe the movement of the person in Plato's allegory of the cave. Be very specific about the various stages in this movement, and then please explain how this allegory relates to our own lives. What is Plato's idea about the best type of life
Multiple regression results : 1. 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 anothe..
What is the most likely reason dot prohibits operation : During an inspection of an abandoned site, a fire marshal discovers the presence of several dynamite sticks within a locked shed attached to a warehouse. Although some sticks are packed within a wooden box, others are lying on shelves.
Auditors perform the steps in which order : Auditors perform the steps in which order
Doctors recommend aspirin for their patients with headaches : A survey claims that 9 out of 10 doctors recommend aspirin for their patients with headaches. To test this claim against the alternative that the actual proportion of doctors who recommend aspirin is less than 0.90, a random sample of 100 doctors ..
Factors that affect the expansion of a multinational firm : There are a number of factors that affect the expansion of a multinational firm, including macroeconomic, political, regulatory, cultural, and social

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Prime number theorem

Dirichlet series

  Proof of bolzano-weierstrass to prove the intermediate value

Every convergent sequence contains either an increasing, or a decreasing subsequence.

  Antisymmetric relations

How many relations on A are both symmetric and antisymmetric?

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Prepare a system of equations

How much money will Dave and Jane raise for charity

  Managing ashland multicomm services

This question is asking you to compare the likelihood of your getting 4 or more subscribers in a sample of 50 when the probability of a subscription has risen from 0.02 to 0.06.]  Talk about the comparison of probabilities in your explanation.

  Skew-symmetric matrices

Skew-symmetric matrices

  Type of taxes and rates in spokane wa

Describe the different type of taxes and their rates in Spokane WA.

  Stratified random sample

Suppose that in the four player game, the person who rolls the smallest number pays $5.00 to the person who rolls the largest number. Calculate each player's expected gain after one round.

  Find the probability density function

Find the probability density function.

  Develop a new linear programming for an aggregate production

Linear programming applied to Aggregate Production Planning of Flat Screen Monitor

  Discrete-time model for an economy

Discrete-time model for an economy

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd