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:

• Determine if the above relation (A, S) defines a function or not.
• Using Excel, draw a scatter diagram of data. Click here 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 $25000.

Requirements:

• Paper must be written in 3^rd person.
• Your paper should be 4-5 pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library is a great place to find resources. Your textbook is a credible resource.
• Include a title page, introduction, body, conclusion, and a reference page.
• The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.
• The body of your paper should answer 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 the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
• Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.
• Document formatting, citations, and style should conform to the CSU-Global Virtual Library CSU-Global Guide to Writing and APA: Introduction. A short summary containing much that you need to know about paper formatting, citations, and references is contained in theNew Sample APA Paper. In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).

Option #2: Demand and Pricing

As a marketing manager, you wish to find a function that relates the demand D for men’s shirts, and P the price of one shirt. Based on the price history, the following data were collected.

• Determine if the above relation (P, D) defines a function or not?
• Using Excel, draw a scatter diagram of data. Click here 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 in the scatter diagram.
• Interpret the slope and y-intercept of this equation.
• Express this equation as a function D of P and find its domain.
• How many shirts will be demanded if the price is $30?

Requirements:

1. Paper must be written in 3^rd person.
2. Your paper should be 4-5 pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library is a great place to find resources. Your textbook is a credible resource.
3. Include a title page, introduction, body, conclusion, and a reference page.
4. The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.
5. The body of your paper should answer 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.
6. The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
7. Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.
8. Document formatting, citations, and style should conform to the CSU-Global Virtual Library CSU-Global Guide to Writing and APA: Introduction. A short summary containing much that you need to know about paper formatting, citations, and references is contained in theNew Sample APA Paper. In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).