MATH 122 CSU GLOBAL Analyzing Advertising Expenditure Paper

User Generated

Cnenqvfr27

Mathematics

MATH 122

Colorado State University Global Campus

MATH

Description

As a data scientist of a company, you want to analyze the following data collected by your company which relates the advertising expenditure A in thousands of dollars to total sales S in thousands of dollars. The following table shows this relationship:

Advertising Expenditure (A)

Total Sales (S)

36

335

37.5

341

38

342

38

342

41

345

42

350.2

43

360

  • Determine if the above relation (A, S) defines a function or not.
  • Using Excel, draw a scatter diagram of data. Click here (Links to an external site.)Links to an external site. for a video explanation on how to create a scatter plot and linear regression.
  • Using Excel, find the line of the best fit the models.
  • Add this line to the scatter diagram.
  • Interpret the slope and y-intercept of this equation.
  • Express this equation as a function S of A and find its domain.
  • Predict the sales if the advertising expenditure is $48000.

Explanation & Answer:
4 pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, please find the solution attached

Running head: ANALYZING ADVERTISING EXPENDITURE

Analyzing Advertising Expenditure
Your name
Subject
Institution
Name of the Professor
Date

1

ANALYZING ADVERTISING EXPENDITURE

2

Analyzing Advertising Expenditure
Introduction
There is a need for advertising analysis because of the increase in promotional costs. The
analysis is carried out at each and every step of advertising process: during developing of the
message, preparing the copy and even after rolling out the advertisement because any mistake
can amount to a big ...


Anonymous
Just what I needed. Studypool is a lifesaver!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags