# Have two ms excel assignment i need help with

Here are the basic of the assignment:

Question 10-50

A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales.

a)      Assume the only factor influencing monthly sales is price. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best?

c)      Using the best-fitting equation, predict sales during a month in which the price is \$470.

Question 12-64

Let Yt be the sales during month t (in thousands of dollars) for a photography studio, and let Pt be the price charged for portraits during month t. The data are in the file P11_45.xlsx. Use regression to fit the following model to these data:

Yt = a + b1Yt−1 + b2Pt + et

This equation indicates that last month’s sales and the current month’s price are explanatory variables. The last term, et, is an error term. a.          If the price of a portrait during month 21 is \$10,

what would you predict for sales in month 21? b.      Does there appear to be a problem with

autocorrelation of the residuals?

63.

59.

(550 words)

Approximate price: \$22

## How it Works

1

It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.

2

Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.

3

After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.

4

Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!