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…

College Algebra

7th Edition

ISBN:9781305115545

Author:James Stewart, Lothar Redlin, Saleem Watson

Publisher:James Stewart, Lothar Redlin, Saleem Watson

Chapter1: Equations And Graphs

Section: Chapter Questions

Problem 8T

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