Question

In: Statistics and Probability

How do I include the data? The site keeps telling me the question is too long...

How do I include the data? The site keeps telling me the question is too long when I include it and when I try to add the 2 pictures it will only let me add one pic.

With milk sales sagging of late, The Milk Processor Education Program (MPEP) decided to move on from the famous "Got Milk" ad slogan in favor of a new one, "Milk Life." The new tagline emphasizes milk's nutritional benefits, including its protein content. MPEP began collecting data on the number of gallons of milk households consumed weekly (in millions), weekly price per gallon, and weekly expenditures on milk advertising (in hundreds of dollars) for the period following the launch of the new campaign. These data, in forms to estimate both a linear model and log-linear model, are available via the link below. Use these data to perform two regressions: a linear regression and a log-linear regression. Which model does a better job fitting the data?
The (Linear) or (Log-linear) model. Suppose that the weekly price of milk is $3.40 per gallon and MPEP decides to ramp up weekly advertising by 35 percent to $150 (in hundreds). Use the best-fitting regression model to estimate the weekly quantity of milk consumed after this advertising increase. Instructions: Round your intermediate calculations and enter your response rounded to three decimal places. _____million gallons per week

Solutions

Expert Solution

For linear regression model, the regression equation is defined as,

Under the Homoskedasticity assumption, the expected value of error term u_i will be zero

Now, the regression analysis is done in excel by following steps

Step 1: Write the data values in excel. The screenshot is shown below,

Step 2: DATA > Data Analysis > Regression > OK. The screenshot is shown below,

Step 3: Select Input Y Range: 'Q' column, Input X Range: 'P and A' column then OK. The screenshot is shown below,

The result is obtained. The screenshot is shown below,

The regression equation is,

The R square value is,

Now,

For log linear regression model, the regression equation is defined as,

(since it is a log-linear, we will use log of variable Q and linear of variable P and A, while if asked for log-log model we will log of each variable)

the regression analysis is done in excel by following steps

Step 1: Write the data values in excel. The screenshot is shown below,

Step 2: DATA > Data Analysis > Regression > OK. The screenshot is shown below,

Step 3: Select Input Y Range: 'ln(Q)' column, Input X Range: 'P and A' column then OK. The screenshot is shown below,

The result is obtained. The screenshot is shown below,

The regression equation is,

The R square value is,

From the above two model, the R square value for linear model is greater than to log linear model hence linear model is better model compare to log linear model.

For linear model, the regression equation is,

For 35% ($150 in hundreds) increase in advertisement cost, while keeping the price same.

consumption of milk will increase by 0.699657 gallons of milk (in millions) weekly


Related Solutions

My Teacher keeps telling me I don't have a Thesis. I thought I hada good thesis....
My Teacher keeps telling me I don't have a Thesis. I thought I hada good thesis. Please help! Bud Light in advertising             One of the most effective ways for businesses to thrive is to use effective advertising, whether the ad is on TV, magazines, social media or even movies. The goal is to create enticement for a purchase over the competitor’s product. Budweiser is great example of a billion dollar company that has always maintained a strong record of...
The data table is too large to be put in the question here is where I...
The data table is too large to be put in the question here is where I collected the data: Visit the NASDAQ historical prices weblink(https://finance.yahoo.com/quote/GOOG/history/). First, set the date range to be for 1.16.18- 2.15.19. [Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer]. Normal distribution Average=1110.68525 Standard Deviation= 65.5518337 Mode=...
How do I draw a complete subgroup diagram? The question asks me to give a complete...
How do I draw a complete subgroup diagram? The question asks me to give a complete subgroup diagram for Z25x
(Could you solve this by using a financial calculator and just telling me what I need...
(Could you solve this by using a financial calculator and just telling me what I need to input) You would like to have the current equivalent in terms of today's buying power of $3,000 in years 4 5 and 6 How much would you have to invest in years 1, 2 and 3 (the same amount in each year in nominal terms) to fund this level of real consumption? You expect inflation to be 3% per year over that time...
Can anyone considerably dumb down what this abstract is telling me? I feel like reading this...
Can anyone considerably dumb down what this abstract is telling me? I feel like reading this is like reading Latin to me. Can someone help me break down what is being said. Thank you so much. Methyltransferase Set7/9 regulates p53 activity by interacting with Sirtuin 1 (SIRT1) Numerous studies indicate that Sirtuin 1 (SIRT1), a mammalian nicotinamide adenine dinucleotide (NAD+ )-dependent histone deacetylase (HDAC), plays a crucial role in p53-mediated stress responses by deacetylating p53. Nevertheless, the acetylation levels of...
java beginner level how do i add messages that say win, too high or too low...
java beginner level how do i add messages that say win, too high or too low for a lottery number generator guessing game? //generate lottery numbers int lottery = (int) (Math.random() * 500); int guess = 0; boolean correct = false; // prompt user to enter a guess Scanner input = new Scanner(System.in); System.out.print ("Enter your lottery pick (three digits): "); int number = input.nextInt(); // keep asking user until user enters a 3-digit number while (guess < 100 ||...
Ethics class how do you think the Me Too movement changed the outlook on sexual morality...
Ethics class how do you think the Me Too movement changed the outlook on sexual morality in politics?
REFER TO CANADIAN SOLAR CASE ... I DONT KNOW HOW TO ATTACH IT, its too long...
REFER TO CANADIAN SOLAR CASE ... I DONT KNOW HOW TO ATTACH IT, its too long to type... PART A:Explain the CAGE model, its components, and its usefulness in evaluating international business decisions. PART B:For Canadian Solar, use the CAGE model to evaluate the challenges inherent in the joint venture decision.
REFER TO CANADIAN SOLAR CASE ... its too long to post, I dont know how to...
REFER TO CANADIAN SOLAR CASE ... its too long to post, I dont know how to attach it. a) Should Canadian Solar try to be global? Please justify your answer. b) What global strategy would you recommend that Canadian Solar pursue? Please justify your answer.
how do i start with this question
how do i start with this question
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT