Validating a Multiple Regression Model

profileshaon.3
multiple_regression_excel_template.xlsx

Sheet1

Sales Direct Newspaper Television
15.98 1.05 1.35 1.55
21.59 1.29 2.25 1.97
25.47 0.96 1.79 1.64
16.02 1.51 1.73 1.73
16.58 1.3 1.71 1.61
20.1 1.06 1.61 1.82
17.49 0.86 1.62 1.97
22.53 0.78 2.2 1.61
23.98 1.2 1.77 1.13
18.96 0.83 1.17 1.77
24.64 1.01 1.76 2.04
19.52 1.34 1.81 1.63
19.97 0.55 2.25 1.93
18.86 1.06 1.98 1.63
22.79 0.9 1.54 2.27
20.38 1.88 1.15 1.45
16.51 0.51 1.19 1.93
18.32 0.53 1.75 1.44
16.04 1.21 1.01 1.46
18.91 0.9 1.68 1.66
20.09 0.97 1.72 1.59
19.83 1.01 1.72 1.42
18.42 1.29 1.47 2.05
21.99 1.35 1.94 2.28
20.57 1.07 2.31 1.77

Sheet2

Sheet3