EBK BUSINESS STATISTICS
8th Edition
ISBN: 9780135179833
Author: STEPHAN
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Is there a way to calculate the second part of this problem using excel?
An appliance store wants to conduct an experiment to determine the effect of advertising on sales revenue. The data table contains the advertising expenditure (in $100s) and sales revenue (in $100s) in the past 5 months. Below the data table, you will see the results of the regression analysis that was performed using Excel. You need to decide what the sales revenue will be with an advertising expenditure of $600, if possible. Would you be able to use the regression equation to predict the sales revenue? If so, what will be the sales revenue rounded to the nearest dollar? Support your answer.
Advertising expenditure ($100s)
Sales Revenue ($100s)
1
1
2
1
3
2
4
2
5
4
Coefficients
Standard Error
t Stat
P-value
Intercept
-0.1
0.635085296
-0.157459164
0.88488398
X Variable 1
0.7
0.191485422
3.655630775
0.035352847
Illustrate the regression equation?
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use exponential regression to fit a model to these data. b. If spending continues at this rate, what will the graduate’s credit card debt be one year after graduating?arrow_forwardLife Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forwardDoes Table 1 represent a linear function? If so, finda linear equation that models the data.arrow_forward
- Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?arrow_forwardXYZ Corporation Stock Prices The following table shows the average stock price, in dollars, of XYZ Corporation in the given month. Month Stock price January 2011 43.71 February 2011 44.22 March 2011 44.44 April 2011 45.17 May 2011 45.97 a. Find the equation of the regression line. Round the regression coefficients to three decimal places. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict the stock price to be in January 2012? January 2013?arrow_forwardDemand for Candy Bars In this problem you will determine a linear demand equation that describes the demand for candy bars in your class. Survey your classmates to determine what price they would be willing to pay for a candy bar. Your survey form might look like the sample to the left. a Make a table of the number of respondents who answered yes at each price level. b Make a scatter plot of your data. c Find and graph the regression line y=mp+b, which gives the number of respondents y who would buy a candy bar if the price were p cents. This is the demand equation. Why is the slope m negative? d What is the p-intercept of the demand equation? What does this intercept tell you about pricing candy bars? Would you buy a candy bar from the vending machine in the hallway if the price is as indicated. Price Yes or No 50 75 1.00 1.25 1.50 1.75 2.00arrow_forward
- Cable TV The following table shows the number C. in millions, of basic subscribers to cable TV in the indicated year These data are from the Statistical Abstract of the United States. Year 1975 1980 1985 1990 1995 2000 C 9.8 17.5 35.4 50.5 60.6 60.6 a. Use regression to find a logistic model for these data. b. By what annual percentage would you expect the number of cable subscribers to grow in the absence of limiting factors? c. The estimated number of subscribers in 2005 was 65.3million. What light does this shed on the model you found in part a?arrow_forwardUsing your graphing calculator, make a scatter plot of the data from the table. Then graph your model from Question 2 along with the data. How well does your model fit the data? What could you do to try to improve your model?arrow_forwardSuppose that a simple linear regression model is appropriate for describing the relationship between y = house price (in dollars) and x = house size (in square feet) for houses in a large city. The population regression line is y = 22,500 + 43x and ?e = 4,000. b) Approximately what proportion of 2,000 sq ft homes would be priced over $110,000? (You may need to use a table. Round your answer to four decimal places.) Approximately what proportion of 2,000 sq ft homes would be priced under $100,000? (You may need to use a table. Round your answer to four decimal places.)arrow_forward
- Problem: The following calculations have been made for prices of twelve stocks (X) on the Calcutta Stock Exchange on a certain day along with the volume of sales in thousands of shares (Y). From these calculations find the regression equation of prices on stocks, on the volume of sales of shares.arrow_forwardparts d, e and f please.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY