The Regression MenuAppendix to Chapter 4 Regression Using Spreadsheets 183Regression
Input
$A$2:$A$1 8
$B$2:$B$1 8Input Y Range:
Input X Range:95 %Labels Constant is Zero
Confidence LevelResiduals
Standardized ResidualsResidual Plots
Line Fit PlotsOutput options
Output Range: $F$2
New Worksheet Ply:
New Workbook
ResidualsNormal Probability PlotsNormal ProbabilityHelpCancelOK1 2 3 4 5 6 7 8 910
11
12
13
14
15
16
17
18
19
20ABCDEFTABLE 4A.1
Regression Data
AB C D E
1
2 Seats Price C Price Income
3 64.8 250 250 104.0
4 33.6 265 250 101.5
5 37.8 265 240 103.0
6 83.3 240 240 105.0
7 111.7 230 240 100.0
8 137.5 225 260 96.5
9 109.5 225 250 93.3
10 96.8 220 240 95.0
11 59.5 230 240 97.0
12 83.2 235 250 99.0
13 90.5 245 250 102.5
14 105.5 240 240 105.0
15 75.7 250 220 108.5
16 91.6 240 230 108.5
17 112.7 240 250 108.0
18 102.2 235 240 109.0
19c04EstimatingandForecastingDemand.qxd 9/5/11 5:49 PM Page 183