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.

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)