14 Nov UoP Week 5 Advertisement Expenditures and Sales Revenues Relationship Discussion
Post a total of three substantive responses over two separate days for full participation: includes your initial post and two replies to other students or your faculty member.
Due Day 3 (35 points)
Respond to each of the following questions in a minimum of 175 words.
Models help us describe and summarize relationships between variables. Understanding how process variables relate to each other helps businesses predict and improve performance. For example, a marketing manager might be interested in modeling the relationship between advertisement expenditures and sales revenues.
Use the Week 5 Discussion Data (in Resources below) and respond to the questions that follow:
A. Construct a scatter plot with this data. (Refer to Example 3 Scatter Linear Regression Analysis).
B. Do you observe a relationship between both variables? (Refer to LO 12-2).
C. Use Excel to fit a linear trend line to the data. What is the fitted regression model? (Refer to LO 12-3).
D. What is the slope? What does the slope tell us? Is the slope significant? (Refer to LO 12-2).
E. What is the intercept? Is it meaningful?
F. What is the value of the regression coefficient, r? What is the value of the coefficient of determination, R2? What does R2 tell us? (Refer to LO 12-4).
G. Use the model to predict sales when the business spends $885 ($'000) in the advertisement. Does the model underestimate or overestimates sales?
Due Day 7 (5 points)
Reply to at least two of your classmates or your faculty member. Be constructive and professional.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.