n order to predict how a school district would have scored when accounting for pawerty and other income measures Cincinati Enquirer gethered data from verious sources. An ovarall score for passage percentages of students for each district is computed which is based on test scores for math, science, language and so on. The percentage of a school district students on Aid for Dependent Childeren (ADC), the percentage who quality for free or reduced price lunches, average income of each district, are also available.on the data file Enquirer.xls. Estimate a linear regression of passing percentages on the three expanatory variables. What is SST, SSR, SSE, coefficient of determination, estimated variabce of error. Does the explanatory variable explain the variabability in passage rates.
n order to predict how a school district would have scored when accounting for pawerty and other income measures Cincinati Enquirer gethered data from verious sources. An ovarall score for passage percentages of students for each district is computed which is based on test scores for math, science, language and so on. The percentage of a school district students on Aid for Dependent Childeren (ADC), the percentage who quality for free or reduced price lunches, average income of each district, are also available.on the data file Enquirer.xls. Estimate a linear regression of passing percentages on the three expanatory variables. What is SST, SSR, SSE, coefficient of determination, estimated variabce of error. Does the explanatory variable explain the variabability in passage rates.
Chapter5: Decimals
Section5.5: Averages And Probability
Problem 400E: The cash register receipts each day last week at a coffee shop were $1,845. $1,520. $1,438, $1,682,...
Related questions
Question
- In order to predict how a school district would have scored when accounting for pawerty and other income measures Cincinati Enquirer gethered data from verious sources. An ovarall score for passage percentages of students for each district is computed which is based on test scores for math, science, language and so on. The percentage of a school district students on Aid for Dependent Childeren (ADC), the percentage who quality for free or reduced price lunches, average income of each district, are also available.on the data file Enquirer.xls.
- Estimate a linear regression of passing percentages on the three expanatory variables.
- What is SST, SSR, SSE, coefficient of determination, estimated variabce of error.
- Does the explanatory variable explain the variabability in passage rates.
Transcribed Image Text:1
Rank
School District
County
% Passed % on ADC % Free Lunch Median Income
2
1
Ottawa Hills Local
Lucas
93.85
0.11
48231
Wyoming City
Oakwood City
Madeira City
3
2
Hamilton
93.08
2.95
4.59
42672
Montgome
Hamilton
4
3
92.92
0.2
0.38
42403
5
4
92.37
1.5
4.83
32889
6.
5
Indian Hill Ex Vill
Hamilton
91.77
1.23
2.7
44135
Solon City
Cuyahoga
Cuyahoga
7
6.
90.77
0.68
2.24
34993
Chagrin Falls Ex Vill
Mariemont City
Upper Arlington City
7
89.89
0.47
0.44
38921
9.
Hamilton
89.8
3
2.97
31823
10
Franklin
89.77
0.24
0.92
38358
11
10
Granville Ex Vill
Licking
89.22
1.14
36235
12
11
Hudson Local
Summit
88.79
0.73
1.28
48281
13
12
Bexley City
Franklin
88.44
0.88
5.02
34277
14
13
Kalida Local
Putnam
88.43
0.13
4.48
25981
Beachwood City
Cuyahoga
Grandview Heights City Franklin
15
14
88.14
0.87
3.73
34757
16
15
87.76
2.26
9.83
27402
17
16
New Knoxville Local
Auglaize
87.52
0.57
5.9
19757
Highland Local
Aurora City
18
17
Medina
87.48
1.21
6.01
32620
19
18
Portage
87.47
1.63
2.79
35612
20
19
Orange City
Cuyahoga
87.4
0.37
3.95
45251
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 3 images
Recommended textbooks for you