The following chart is data over an 8-month period that shows how much a company spent in advertising and the sales revenue for that month MONTHADVERTISING $SALES $March90056000April270089200May315098500June130054000July340097000Aug150056000Sept230093000Oct225079000 What is the linear equation (y = mx + b form) that best approximates the relationship between advertising dollars spent(x) and sales revenue(y) based on the above 8 months of data? (round to 2 decimals for the slope and the y intercept) describe how you utilized excel to arrive at this equation

The data is x(advertising) y(sales) 900 56000 2700 89200 3150 98500 1300 54000 3400…

Answered: The following chart is data over an…

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 19PFA

See similar textbooks

Related questions

Question

The following chart is data over an 8-month period that shows how much a company spent in advertising and the sales revenue for that month

MONTH	ADVERTISING $	SALES $
March	900	56000
April	2700	89200
May	3150	98500
June	1300	54000
July	3400	97000
Aug	1500	56000
Sept	2300	93000
Oct	2250	79000

What is the linear equation (y = mx + b form) that best approximates the relationship between advertising dollars spent(x) and sales revenue(y) based on the above 8 months of data? (round to 2 decimals for the slope and the y intercept) describe how you utilized excel to arrive at this equation

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Hello, I am having trouble understanding how to get the (x-x), (y-y), (x-x) (y-y), and (x-y)^2. I dont understand in the data analysis where I input the data. I tried in the Regression but I dont know how to find the output range.

Solution