Stats assignment

Coffee Palace s manager, Joe Felan, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Joe has gathered the following data, which show the numbers of these coffees sold over six different price values: Price / Number Sold. $2.70 / 760, $3.50 / 510, $2.00 / 980, $4.20 / 250, $3.10 / 320, $4.05 / 480. Using these data, how many mocha latte coffees would forecast to be sold according to simple linear regression if the price per cup were $2.80? (Answer in Excel) 

Additional Requirements 

Other Requirements: Answer in Excel only please.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *