# Stats assignment

Question # 00002282 Posted By: mac123 Updated on: 10/13/2013 04:14 PM Due on: 10/15/2013
Subject Mathematics Topic General Mathematics Tutorials:
Question

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)

Other Requirements: Answer in Excel only please.

Tutorials for this Question
1. ## Solution: Stats assignment

Tutorial # 00002100 Posted By: mac123 Posted on: 10/13/2013 04:15 PM
Puchased By: 2
Tutorial Preview
The solution of Stats assignment...
Attachments
stats_2.xlsx (11.72 KB)

Great! We have found the solution of this question!