Born outside the United States
Stu ID |
Age |
Total Crd Hrs |
GPA |
Hrs spend on sch wrk |
205 |
26 |
48 |
2.90 |
25 |
209 |
57 |
23 |
2.98 |
7 |
198 |
32 |
78 |
3.40 |
8 |
230 |
44 |
34 |
3.70 |
10 |
135 |
19 |
0 |
3.00 |
4 |
178 |
34 |
51 |
3.50 |
8 |
224 |
23 |
26 |
3.00 |
20 |
328 |
45 |
23 |
3.25 |
12 |
169 |
19 |
23 |
3.00 |
4 |
164 |
26 |
51 |
3.8 |
2 |
266 |
49 |
20 |
3.91 |
10 |
202 |
20 |
12 |
3.60 |
4 |
219 |
57 |
35 |
2.98 |
7 |
167 |
37 |
56 |
2.86 |
3 |
324 |
21 |
24 |
3.80 |
8 |
179 |
16 |
15 |
3.90 |
12 |
45 |
19 |
44 |
2.80 |
10 |
32 |
24 |
44 |
3.70 |
4 |
246 |
34 |
60 |
2.90 |
4 |
174 |
19 |
23 |
3.30 |
12 |
303 |
21 |
51 |
2.00 |
2 |
242 |
19 |
50 |
3.40 |
10 |
184 |
25 |
35 |
3.10 |
5 |
272 |
19 |
31 |
3.4 |
12 |
9 |
18 |
12 |
4.00 |
25 |
228 |
21 |
18 |
3.50 |
5 |
226 |
24 |
12 |
2.43 |
6 |
146 |
26 |
0 |
3.20 |
10 |
318 |
20 |
13 |
2.70 |
4 |
44 |
25 |
50 |
3.00 |
4 |
For students GPA and the number of hours spent on homework:
Ʃx = | 97.01 |
Ʃy = | 257 |
Ʃxy = | 851.48 |
Ʃx² = | 319.9959 |
Ʃy² = | 3231 |
Sample size, n = | 30 |
SSxx = Ʃx² - (Ʃx)²/n = 319.9959 - (97.01)²/30 = | 6.29789667 |
SSyy = Ʃy² - (Ʃy)²/n = 3231 - (257)²/30 = | 1029.36667 |
SSxy = Ʃxy - (Ʃx)(Ʃy)/n = 851.48 - (97.01)(257)/30 = | 20.4276667 |
Correlation coefficient, r = SSxy/√(SSxx*SSyy) = 20.42767/√(6.2979*1029.36667) = 0.2537
df = n-2 = 28
Critical value of r at 0.05, rc = 0.361
As |r| < rc, we fail to reject the null hypothesis.
There is no correlation between students GPA and the number of hours spent on homework.
-------------
For students Age and the number of hours spent on homework:
Ʃx = | 839 |
Ʃy = | 257 |
Ʃxy = | 7035 |
Ʃx² = | 27393 |
Ʃy² = | 3231 |
Sample size, n = | 30 |
SSxx = Ʃx² - (Ʃx)²/n = 27393 - (839)²/30 = | 3928.96667 |
SSyy = Ʃy² - (Ʃy)²/n = 3231 - (257)²/30 = | 1029.36667 |
SSxy = Ʃxy - (Ʃx)(Ʃy)/n = 7035 - (839)(257)/30 = | -152.43333 |
Correlation coefficient, r = SSxy/√(SSxx*SSyy) = -152.43333/√(3928.96667*1029.36667) = -0.0758
df = n-2 = 28
Critical value of r at 0.05, rc = 0.361
As |r| < rc, we fail to reject the null hypothesis.
There is no correlation between students Age and the number of hours spent on homework.
Born outside the United States Stu ID Age Total Crd Hrs GPA Hrs spend on sch...
Pls both parts for UPVOTE Using Excel create four histograms, properly labeled, depicting the data from the frequency distributions in #a and #b below. a) Using the variable Age, construct TWO frequency distributions to summarize the Ages of students born in the USA and those born outside the USA. Use 5 classes to construct your frequency distribution. For each frequency distribution, show your calculations for the class width and then list the: Lower limits and upper limits Class boundaries Class...
File Ed Yew ranoform e Srepha Anaivza Custom Hours Work GPA Absences yar ed less than 1... 3.00 4.00 less than 1.. 2 4.00 2.00 less than 1... 2.50 3.00 less than 1.. 3.80 1.00 less than 1.. 2.70 2.00 less than 1. 3.20 5.00 7 less than 1. 4.00 6.00 less than 1.. 8 3.80 7.00 less than 1... 2.90 9.00 10 less than 1... 3.10 4.00 11 less than 1. 3.10 7.00 12 less than 1... 2.00 8.00...
Using the answers from the table above, answer ALL of the questions below. For questions 1 - 13, draw a normal curve and indicate the area that you are calculating the probability of. For questions 14 – 22, use the appropriate formulas and show all of your calculations. Be sure to turn in the table above along with your answers to all of the questions below. Place your answers in a folder with your name clearly written at the top...
The subjects in the data are college students. In the data, id is student ID, anxiety is student’s anxiety score via Anxiety Scale, selfest is student’s self-esteem score via Rosenberg Self-esteem Scale, GPA is student’s GPA; for gender, 0=female, 1=male; for grade, 1=freshman, 2=junior, 3=senior. We have known that population mean for Anxiety Scale is μ=60 with σ=10. Raise relevant questions ( 2 questions is fine) about the data extensively, the questions can be either about descriptive analysis or inferential...
Data were collected during the time period in which a constant number of checkout counters were open. The total number of customers in the store and the waiting times in minutes were recorded. a) Use Excel to construct the scatter plot. b) Determine the linear regression equation between a number of customers and waiting time include that on the graph c) Predict the waiting period when there are 20 customers in the store. d) Show r= coefficient of regression and...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data432.dat gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and draw...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data42.datgives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and draw...
1. The data set on sheet #1 gives data on GPA category and number of hours studied. Construct comparative box plots of the data first GPA category. Then conduct two-sample t-test on the data for whether GPA category influences the number of hours studied. Be prepared to explain the results of the test and the meaning of the boxplots and how they relate to each other. Then redo the analysis by replacing the ordinal GPA category with a numerical dummy...
f you are male, use the men’s heights and shoe sizes as your data. If you are female, use the women’s heights and shoe sizes as your data. Student # Gender Height Shoe Age Hand 1 F 68 8.5 20 R 2 F 60 5.5 27 R 3 F 64 7 31 R 4 F 67 7.5 19 R 5 F 65 8 20 R 6 F 66 9 29 R 7 F 62 9.5 30 L 8 F 63...