Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Coffee vendors have been getting popular in the city of Auckland. A vendor is interested in knowing how temperature (in degrees Celsius) impacts daily hot

Coffee vendors have been getting popular in the city of Auckland. A vendor is interested in knowing how temperature (in degrees Celsius) impacts daily hot coffee sales revenue (in $00’s). A random sample of 6 days was taken, with the daily hot coffee sales revenue and the corresponding temperature of that day noted. The regression is run and output from excel is given

SUMMARY OUTPUT        
         
Regression Statistics       
Multiple R0.864422274       
R Square0.747225868       
Adjusted R Square0.684032336       
Standard Error5.202681673       
Observations6       
         
ANOVA        
 dfSSMSFSignificance F   
Regression1320.061747320.061711.824404090.026325931   
Residual4108.271586327.0679     
Total5428.3333333      
         
 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept27.717871495.6628960384.8946460.00807501111.995151543.4405914711.995151543.44059147
Tempreature (X)-0.6942771080.201903206-3.438660.026325931-1.254850276-0.133703941-1.25485028-0.133703941

a. Interpret the coefficient of X-variable. [Hint: note sales revenue (in $00’s).
b. Estimate daily hot beverage sales revenue on a day of 25 degrees Celsius using estimated Model.
c. Calculate error value for the first observation with 25 degrees Celsius.
d. State value of Sum Square Regression (SSR).
e. State coefficient of determination and interpret. Conduct a test of the slope (coefficient of temperature) to determine at the 10% significance level whether there is existence of negative linear relationship between temperature and beverage sales revenue. [Hint: show six step procedure and utilize excel output wherever you can).

Step by Step Solution

3.48 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

Required solution of all parts e ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
635e1c3abe8cb_181536.pdf

180 KBs PDF File

Word file Icon
635e1c3abe8cb_181536.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics

Authors: Paul Krugman, Robin Wells

3rd edition

978-1429283427, 1429283424, 978-1464104213, 1464104212, 978-1429283434

More Books

Students also viewed these Accounting questions