MATH 121 CSU Global Advertising Expenditure Analysis

MATH 121 CSU Global Advertising Expenditure Analysis


Just $7 Welcome
Order Now


MATH 121

Colorado State University: Global Campus


Question Description

I’m working on a algebra exercise and need guidance to help me learn.



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)
19 325
21 329
21.5 328
23 333
23 331
26 340
27.3 341


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


  1. Your paper should be 2-3 pages in length (not counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library (Links to an external site.) is a great place to find resources. Your textbook is a credible resource.
  2. Include a title page, introduction, body, conclusion, and a reference page.
    1. The introduction should describe or summarize the topic or problem. It might discuss the general applications of the topic or it might introduce the unique terminology associated with the topic.
    2. The body of your paper should address the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
  • The conclusion should summarize your thoughts about what you have determined from your analysis in completing the assignment. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
  1. Include any tables of data or calculations, calculated values, and/or graphs referenced in the paper. (Note: The minimum required length excludes any tables, graphs, etc.)
  2. Document formatting, citations, and style should conform to APA style and examples can be found in the following links: