Q T # 2

profilerelic415
copy_of_qct2_chapter_5spreadsheet.xls

Sheet1

Salvator's chapter 5 appendix problem 2 (p.215)
Quakity Control Revenues Forecast
Z Y Z FY
3 44 2 39.68
4 40 3
3 42 4
3 46 5
4 48 6
5 52 7
6 54 8
7 58 9
7 56
8 60
Please follow the steps for simple regression to obtain the regression equation (pp.211-215)
Light, Andrew Tsung-Hui (School of Business): To be done by students

Sheet2

Sheet3