Construct a scatter plot with data

Assignment Help Basic Statistics
Reference no: EM132848597

Models help us describe and summarize relationships between variables. Understanding how process variables relate to each other helps businesses predict and improve performance. For example, a marketing manager might be interested in modeling the relationship between advertisement expenditures and sales revenues.

Consider the dataset below and respond to the questions that follow:

Advertisement (000) Sales (000)

1068 4489
1026 5611
767 3290
885 4113
1156 4883
1146 5425
892 4414
938 5506
769 3346
677 3673
1184 6542
1009 5088

-Construct a scatter plot with this data.

-Do you observe a relationship between both variables?

-Use Excel to fit a linear regression line to the data. What is the fitted regression model? (Hint: You can follow the steps outlined on page 497 of the textbook.)

-What is the slope? What does the slope tell us?Is the slope significant?

-What is the intercept? Is it meaningful?

-What is the value of the regression coefficient,r? What is the value of the coefficient of determination, r^2? What does r^2 tell us?

-Use the model to predict sales and the business spends $950,000 in advertisement. Does the model underestimate or overestimates ales?

Reference no: EM132848597

Questions Cloud

Discuss what is employee performance : Discuss what is Employee Performance. An exploration of the evolving role of a Strategic Human Resource Management (SHRM) topic.
Calculate each hotel respective share : If they host a joint Christmas party. the cost per employee is only $40. Calculate each hotel's respective share of the cost
Do think that intelligence gradually declines : Do you think that intelligence gradually declines during adulthood? Why do you think this is so? How do you define success? Why do you define success
Motivated reasoning and intelligence : Show by a simple example that if agent A is more adept at coming up with rationales than agent B, then she can satisfy her true desires while agent B may not.
Construct a scatter plot with data : -Construct a scatter plot with this data. -Do you observe a relationship between both variables?
How much money did the venture capitalists receive : Of the 9 million shares sold, 5 million shares were primary shares being sold by the company, How much money did the venture capitalists receive
How does an emphasis on quality reduce clinician : What actions can you take? Can you limit patient visits to a level you can successfully handle? Can you close a practice due to questionable safety?
What is the cash balance at year-end : Tennison Corporation had the transactions in its first year of operations: Sales (90% collected in year) $1,500,000. What is the cash balance at year-end
Create a team name for a work team : Are these things really important? Why? How would you create these in a real-world work environment? Create a Team name for a work team

Reviews

Write a Review

Basic Statistics Questions & Answers

  Calculate the value of the test statistic

Calculate the value of the test statistic. Do not assume that the population variances are equal.

  Constructing the confidence interval estimate

What assumption must you make about the population distribution in order to construct the confidence interval estimate in (a)?

  To that end they hoped to achieve a reduction to 20 by

question in 1999 lehman brothers estimated that 48 of its investment bank traders took diverse forms of soft drugs.

  Differentiate parametric from non-parametric tests

For your first Pause-Problem in this chapter, please tell me three things that differentiate parametric from non-parametric tests

  Deaths due to hpv vaccines

Explain why The Canary Party believes that there must be something wrong with the vaccine.

  Discuss about the changes in the confidence interval

Explain whether the width of a confidence interval would increase, decrease or remain the same as a result of each of the following changes.

  Calculate the test statistic and the df

Calculate the test statistic and the df - Write a conclusion, addressing the research question. Your conclusion should include an interpretation of the 95% confidence bound which is given in the above output

  Assume mba graduates have incomes normally distributed with

assume mba graduates have incomes normally distributed with a mean of 100000 and a standard deviation of 20000. law

  What was the standard error of the slope estimate

A regression was carried out aimed at assessing the effect of the offer price of an initial public offering (IPO) on the chances of failure of the firm issuing.

  Determining probability of having type o blood

Select a US citizen and a citizen of China at random, independently of one another. Determine the probability that both have type O blood?

  Site preference for restaurants

Suppose you manage Tennessee Grilled Pork, a fast food restaurant specializing in pork sandwiches and pork chops on a stick. You have decided to build a new restaurant and have 2 possible site locations

  Binomial distribution and forecast

On any given day, about 45% of the stocks on the American Stock Exchange increase in value. A random sample of four independent stocks is chosen.

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