NCAA EXCEL SIMULATION PROJECT



EXCEL REGRESSION PROJECT – SPRING SEMESTER – 2019 - AHS

SET UP INSTRUCTIONS

A. Go to Mr. Scheel’s web page and under Course Materials download the Regression with Excel Sample problem file. All the items listed in green are data that you must record on your paper for each problem. In yellow is the description of each data point that must be included as well. If you have any questions, check with a neighbor or ask Mr. Scheel. There is another file called Excel tips which answers common questions about using Excel. Also there is a file called Regression with Excel FAQ.

B. Open Microsoft Excel on your computer. Click on the Data tab at the top. If you see “Data Analysis” listed in the upper right corner, the spreadsheet is set to go. If not, go to “File”, “Options”, “Add Ins”, “Manage Add Ins”. Make sure the Analysis Toolpak is checked, and it should be set.

REGRESSION TASKS

For each problem listed below, complete the following steps:

A. Enter the data into a spreadsheet tab (include labels at the top).

B. Calculate a regression output report (you choose confidence level) along with a data display (line fit is the common choice).

C. Record and interpret all the critical values from the regression report in the context of the problem(green and yellow areas; sketch graph as well for problems 1 and 2 only)

D. Calculate predictions for the missing chart values by using the least squares regression line formula typed into Excel.

1. (study time, test score): (0, 40), (2, 82), (3, 75), (5, 91), (8, 85), (10, 99), (4, ), (7, ), (12, )

2. (drive length, scoring avg): (290, 70.5), (298, 69.8), (284, 71.0), (300, 70.1), (314, 70.9), (291, 72.2), (294, 71.1), (276, 71.5), (311, 70.6), (295, 70), (282, 72.4), (289, 70.7), (280, 71.9), (304, 69.3), (299, 70.4), (285, ), (296, ),

(308, )

For problems 3 and 4, use the data sets below. Problem #3 is Points For vs Games Won. Problem #4 is Points Allowed vs Games Won. Follow process above. Compare answers.

Points For Points Allowed Games Won

441 250 14

363 380 10

399 378 7

275 409 5

399 327 11

343 321 8

325 315 6

264 452 1

279 328 9

381 378 9

411 392 8

318 400 3

389 311 12

416 385 12

333 297 9

410 423 5

375 300

280 400

450 275

For problems 5, 6 and 7, use the data sets below. Problem #5 is Batting Average vs Runs. Problem #6 is Home Runs vs Runs. Problem #7 is Stolen Bases vs Runs. Follow process above. Compare answers.

Batting Average Home Runs Stolen Bases Runs Scored

275 175 70 800

255 200 40 785

260 150 100 750

240 125 75 640

262 188 49 775

250 240 30 780

271 100 110 740

233 140 25 625

290 125 50

257 210 80

261 80 200

For problems 8, 9, and 10, use the data sets below. Problem #8 is Factor A vs Rating. Problem #9 is Factor B vs Rating. Problem #10 is Factor C vs Rating. Follow process above. Compare answers.

Factor A Factor B Factor C Rating

4 4 2 95

3 2 4 81

4 1 3 84

3 4 4 88

2 2 2 70

3 0 4 66

4 3 4 94

3 3 3

4 2 0

2 4 4

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download