As a marketing manager, you wish to find a function that relates the demand D fo

As a marketing manager, you wish to find a function that relates the demand D fo

As a marketing manager, you wish to find a function that relates the demand D for men’s shirts per month and P the price of one shirt in dollars. Based on the price history, the following data were collected.
Price of One Shirt (P)
Demand (D)
1949
2146
2245
2242
2641
2838
2933
Determine if the above relation (P, D) defines a function or not.
Using Excel, draw a scatter diagram of data. Using Excel, draw a scatter diagram of data. Select the following video link to learn how to create a scatter plot and linear regression: How to Scatter PlotLinks to an external site..
Using Excel, find the line of the best fit of 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 per month will be demanded if the price is $27?