ANSWER ASAP. NEED THE ANSWER WITHIN 1 HOUR. WILL UPVOTESHOW THE EXCEL SOLUTION Print-screen your Excel -Solution and upload it)A study was made by a retail merchant to determine the relation between weekly advertising expenditures and sales. Thefollowing data were recorded:Advertising Costs ($)Sales ($)402025385400395365475440490420560525203050402050402550480510a.Find the equation of the regression line to predict weekly sales from the advertising expenditures.Determine how much will be the sales when advertising costs are 28, 42 and 48Find the correlation coefficient. (Explain your answer)C.

The independent variable is advertising costs. The dependent variable is sales. This is simple…

A study was made by a retail merchant to determine the relation between weekly advertising expenditures and sales. The following data were recorded: Advertising Costs ($) Sales ($) 40 20 25 20 30 50 40 20 50 40 25 50 385 400 395 365 475 440 490 420 560 525 480 510 a. Find the equation of the regression line to predict weekly sales from the advertising expenditures. Determine how much will be the sales when advertising costs are 28, 42 and 48 Find the correlation coefficient. (Explain your answer) C.

A study was made by a retail merchant to determine the relation between weekly advertising expenditures and sales. The following data were recorded: Advertising Costs ($) Sales ($) 40 20 25 20 30 50 40 20 50 40 25 50 385 400 395 365 475 440 490 420 560 525 480 510 a. Find the equation of the regression line to predict weekly sales from the advertising expenditures. Determine how much will be the sales when advertising costs are 28, 42 and 48 Find the correlation coefficient. (Explain your answer) C.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.6: Regression And Median-fit Lines

Problem 1CYU

See similar textbooks

Similar questions

Life 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?2300
Noise and Intelligibility Audiologists study the intelligibility of spoken sentences under different noise levels. Intelligibility, the MRT score, is measured as the percent of a spoken sentence that the listener can decipher at a cesl4ain noise level in decibels (dB). The table shows the results of one such test. (a) Make a scatter plot of the data. (b) Find and graph the regression line. (c) Find the correlation coefficient. Is a linear model appropriate? (d) Use the linear model in put (b) to estimate the intelligibility of a sentence at a 94-dB noise level.
HOW DO YOU SEE IT? Discuss how well a linear model approximates the data shown in each scatter plot.
XYZ 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?