MATH 121 CSU Global Advertising Expenditure Analysis

Option #1: Analyzing Advertising Expenditure

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:

undefined

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.

Requirements:

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:

• Citing and APA Resources (Links to an external site.): document formatting, citations, and style
• New Sample APA Paper (Links to an external site.): A short summary containing much that you need to know about paper formatting, citations, and references
• CSU Global Writing Center (Links to an external site.): many helpful areas, such as: Writing Center, Writing Tips, Template Examples/Papers Essays, and others