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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- project roi excel template
- microsoft excel project plan template
- project roi calculator excel template
- free project tracker excel template
- free excel project management spreadsheet
- excel project management template
- excel project plan template free
- project management excel template free
- excel project tracking spreadsheet free
- excel project tracker template
- project management excel spreadsheet template
- project timeline excel template free