Question
In: Statistics and Probability
On Moodle, you will find a file labelled “Data for Question 4 Assignment 1”. It contains...
-
On Moodle, you will find a file labelled “Data for Question 4 Assignment 1”. It contains data on past students in this course. Under Midterm is information on whether past studentsgot an A grade (A−, A, A+) an F or D grade (D is a passing grade but most students need aC− for it to count towards their program) or Other (any grade in between). Under FinalExam is information on whether students got a D or F grade or anything “better”.
Conduct a test of independence to determine if the Midterm grades are independent of final exam grades. So we can better compare our answers, make Final Exam your row variable and Midterm your column variable. Use α = 0.01.
I attached the table provided below! Please show me or take picture of the excel procedure. This assignment is due in 5 hours if someone could answer before this time I will be ETERNALLY grateful and rate the highest possible, thanks.
| Observation | Midterm | Final Exam |
| 1 | F or D | F or D |
| 2 | F or D | F or D |
| 3 | Other | F or D |
| 4 | F or D | Better |
| 5 | F or D | F or D |
| 6 | F or D | F or D |
| 7 | A grades | Better |
| 8 | Other | F or D |
| 9 | A grades | Better |
| 10 | A grades | Better |
| 11 | F or D | F or D |
| 12 | A grades | Better |
| 13 | F or D | F or D |
| 14 | A grades | Better |
| 15 | F or D | Better |
| 16 | F or D | F or D |
| 17 | F or D | F or D |
| 18 | Other | Better |
| 19 | F or D | F or D |
| 20 | F or D | Better |
| 21 | Other | F or D |
| 22 | F or D | F or D |
| 23 | A grades | Better |
| 24 | A grades | Better |
| 25 | A grades | Better |
| 26 | F or D | F or D |
| 27 | F or D | F or D |
| 28 | Other | F or D |
| 29 | F or D | F or D |
| 30 | Other | F or D |
| 31 | F or D | F or D |
| 32 | Other | Better |
| 33 | F or D | Better |
| 34 | F or D | Better |
| 35 | F or D | F or D |
| 36 | F or D | F or D |
| 37 | F or D | F or D |
| 38 | F or D | F or D |
| 39 | F or D | F or D |
| 40 | F or D | F or D |
| 41 | Other | F or D |
| 42 | Other | F or D |
| 43 | F or D | F or D |
| 44 | Other | F or D |
| 45 | A grades | Better |
| 46 | Other | F or D |
| 47 | F or D | F or D |
| 48 | A grades | F or D |
| 49 | F or D | F or D |
| 50 | A grades | Better |
| 51 | F or D | F or D |
| 52 | F or D | F or D |
| 53 | F or D | F or D |
| 54 | Other | F or D |
| 55 | F or D | F or D |
| 56 | A grades | Better |
| 57 | A grades | Better |
| 58 | Other | F or D |
| 59 | A grades | Better |
| 60 | Other | F or D |
| 61 | A grades | F or D |
| 62 | F or D | F or D |
| 63 | Other | F or D |
| 64 | Other | F or D |
| 65 | F or D | F or D |
| 66 | A grades | F or D |
| 67 | A grades | F or D |
| 68 | Other | F or D |
| 69 | Other | F or D |
| 70 | F or D | F or D |
| 71 | Other | F or D |
| 72 | Other | F or D |
| 73 | A grades | Better |
| 74 | A grades | F or D |
| 75 | Other | F or D |
| 76 | F or D | F or D |
| 77 | F or D | F or D |
| 78 | F or D | F or D |
| 79 | F or D | F or D |
| 80 | Other | F or D |
| 81 | F or D | F or D |
| 82 | F or D | F or D |
| 83 | A grades | Better |
| 84 | F or D | F or D |
| 85 | F or D | F or D |
| 86 | F or D | F or D |
Solutions
Expert Solution
First of all data is sorted and compressed in MS-EXCEL:
- Data in Excel
- Sort Option on right corner
- Select Midterm using levels in "Sort by" dialog box
- Add next level
Final Sorted data that one obtains:
| Observation | Midterm | Final Exam |
| 7 | A grades | Better |
| 9 | A grades | Better |
| 10 | A grades | Better |
| 12 | A grades | Better |
| 14 | A grades | Better |
| 23 | A grades | Better |
| 24 | A grades | Better |
| 25 | A grades | Better |
| 45 | A grades | Better |
| 50 | A grades | Better |
| 56 | A grades | Better |
| 57 | A grades | Better |
| 59 | A grades | Better |
| 73 | A grades | Better |
| 83 | A grades | Better |
| Observation | Midterm | Final Exam |
| 48 | A grades | F or D |
| 61 | A grades | F or D |
| 66 | A grades | F or D |
| 67 | A grades | F or D |
| 74 | A grades | F or D |
| Observation | Midterm | Final Exam |
| 4 | F or D | Better |
| 15 | F or D | Better |
| 20 | F or D | Better |
| 33 | F or D | Better |
| 34 | F or D | Better |
| Observation | Midterm | Final Exam |
| 1 | F or D | F or D |
| 2 | F or D | F or D |
| 5 | F or D | F or D |
| 6 | F or D | F or D |
| 11 | F or D | F or D |
| 13 | F or D | F or D |
| 16 | F or D | F or D |
| 17 | F or D | F or D |
| 19 | F or D | F or D |
| 22 | F or D | F or D |
| 26 | F or D | F or D |
| 27 | F or D | F or D |
| 29 | F or D | F or D |
| 31 | F or D | F or D |
| 35 | F or D | F or D |
| 36 | F or D | F or D |
| 37 | F or D | F or D |
| 38 | F or D | F or D |
| 39 | F or D | F or D |
| 40 | F or D | F or D |
| 43 | F or D | F or D |
| 47 | F or D | F or D |
| 49 | F or D | F or D |
| 51 | F or D | F or D |
| 52 | F or D | F or D |
| 53 | F or D | F or D |
| 55 | F or D | F or D |
| 62 | F or D | F or D |
| 65 | F or D | F or D |
| 70 | F or D | F or D |
| 76 | F or D | F or D |
| 77 | F or D | F or D |
| 78 | F or D | F or D |
| 79 | F or D | F or D |
| 81 | F or D | F or D |
| 82 | F or D | F or D |
| 84 | F or D | F or D |
| 85 | F or D | F or D |
| 86 | F or D | F or D |
| Observation | Midterm | Final Exam |
| 18 | Other | Better |
| 32 | Other | Better |
| Observation | Midterm | Final Exam |
| 3 | Other | F or D |
| 8 | Other | F or D |
| 21 | Other | F or D |
| 28 | Other | F or D |
| 30 | Other | F or D |
| 41 | Other | F or D |
| 42 | Other | F or D |
| 44 | Other | F or D |
| 46 | Other | F or D |
| 54 | Other | F or D |
| 58 | Other | F or D |
| 60 | Other | F or D |
| 63 | Other | F or D |
| 64 | Other | F or D |
| 68 | Other | F or D |
| 69 | Other | F or D |
| 71 | Other | F or D |
| 72 | Other | F or D |
| 75 | Other | F or D |
| 80 | Other | F or D |
See bottom right corner will give respective counts i.e. observed frequency.
Theory and Computation:
| Midterm | Final Exam | Count | Eij | Oij | (Oij-Eij) | (Oij-Eij)^2/Eij | |||
| A grades | Better | 15 | 64*20/86 | 14.88372 | 5 | -9.88372 | 6.563408 | ||
| A grades | F or D | 5 | 22*20/86 | 5.116279 | 15 | 9.883721 | 19.09355 | ||
| F or D | Better | 5 | 64*44/86 | 32.74419 | 39 | 6.255814 | 1.19518 | ||
| F or D | F or D | 39 | 22*44/86 | 11.25581 | 5 | -6.25581 | 3.476888 | ||
| Other | Better | 2 | 64*22/86 | 16.37209 | 20 | 3.627907 | 0.803911 | ||
| Other | F or D | 20 | 22*22/86 | 5.627907 | 2 | -3.62791 | 2.338651 | ||
| 86 | 33.47159 | ||||||||
| Critical value | |||||||||
| df=(m-1)(n-1) | (2-1)*(3-1) | 2 | |||||||
| chitab | CHIINV(0.05,2) | 5.991465 | |||||||
| chical > chitab, we Reject H0. | |||||||||
No, Midterm grades are not independent of final exam grades.
orchestra answered 1 year agoRelated Solutions
On Moodle, you will find a file “Data for Q2 Ass3” which has data on grades...
On Moodle, you will find a file “Data for Q2 Ass3” which has
data on grades in past sections of this course. The variables are
Assignment1 = Grade on Assignment 1 as a percentage Assignment2 =
Grade on Assignment 2 as a percentage Assignment3 = Grade on
Assignment 3 as a percentage Midterm = Midterm Grade as a
percentage Project = Project Grade as a percentage Participation =
Participation Grade as a number out of 5. AssignmentDum = A dummy...
In the Excel data file, the tab labeled Question 1 contains data on the number of...
In the Excel data file, the tab labeled Question 1
contains data on the number of times boys and girls raise their
hands in class. Conduct the t-test: Two-Sample Assuming
Equal Variances.
Males 9,8,4,9,3,8,10,8,9,10,7,6,12
Females 3,5,1,2,6,4,3,6,7,9,7,3,7,6,8,8
a. What is the null hypothesis?
b. What is the research hypothesis?
c. Why run a Two-Sample Assuming Equal Variances
t-test?
d. Interpret the findings. What are the results of the
hypothesis test? Can you reject the null hypothesis?
Consider the program which you can find on Moodle that draws random lines. In this assignment,...
Consider the program which you can find on Moodle that draws
random lines. In this assignment, you will extend that program to
draw triangles and quadrilaterals. Create classes Traingle and
Quadrilaterals. Declare a constructor in each class as follows:
public Triangle (int x1, int y1, int x2, int y2, int x3, int y3,
Color color)
public Quadrilateral (int x1, int y1, int x2, int y2, int x3,
int y3, int x4, int y4, Color color)
Each class of these two...
the assignment folder for this assignment contains a file called values.txt. The first line in the...
the assignment folder for this assignment contains a file called
values.txt. The first line in the file contains the total number of
integers which comes after it. The length of this file will be the
first line plus one lines long.
Implement a MinHeap. Your program should read in input from a
file, add each value to the MinHeap, then after all items are
added, those values are removed from the MinHeap. Create a java
class called MinHeap with the...
The accompanying data file contains 20 observations for t and yt. t 1 2 3 4...
The accompanying data file contains 20 observations for
t and yt.
t
1
2
3
4
5
6
7
8
9
10
yt
13.7
8.9
10.4
9.3
12.1
13.7
11.9
13.9
13.8
13.5
t
11
12
13
14
15
16
17
18
19
20
yt
10.8
10.6
12.3
9.3
11.2
10
10.5
13.7
10.3
10.7
The data are plotted below.
a. Discuss the presence of random variations.
A. The smoother appearance of the graph suggests the presence of
random variations....
If the file circuit.txt contains the following data
Exercise 2:
If the file circuit.txt contains the
following data
3.0
2.1
1.5
1.1
2.6
4.1
The first column is voltage and the second column is the
electric current.
Write program that reads the voltages and currents then
calculates the electric power (P) based on the equation:
Voltage
Current Power
3.0
2.1
(result)
1.5
1.1
(result)
2.6
4.1
(result)
P = v * i
Write your output to the file
results.txt with voltage in the first,
current in the second...
Consider a text file that you will create named “employees.txt”. The file contains data organized according...
Consider a text file that you will create named “employees.txt”.
The file contains data organized according to the following
format:John Smith 10 15Sarah Johnson 40 12Mary Taylor 27 13Jim
Stewart 25 8For instance, “John” is the first name, “Smith” is the
last name, “10” is the number of hours per week, and “15” is the
hourly rate.Write a program that computes the weekly salary of each
employee. The program prints the first name, last name, and weekly
salary of each...
For Question 1-4, We will load 1000_Companies.csv dataset that contains data belongs to 1000 companies such...
For Question 1-4, We will load
1000_Companies.csv dataset that contains data belongs to
1000 companies such as R&D, administration and marketing
spendings and location. We will use this data to build a machine
learning based decision suppport system model to predict companies'
profit.
Question 1: 10 Points (Load Data)
(A) Load the "1000_Companies.csv" dataset - 5 points
(B) Display the first and last 5 rows of this dataset - 5
points
In [ ]:
Question 2: 15 Points (Manipulate...
C ++ Data File Preparation 1. Using the original AL Weather Station Data file find all...
C ++ Data File Preparation
1. Using the original AL Weather Station Data file find all
records that have a bad data flag (-9999) for either the PRCP, TMAX
or TMIN fields. Produce a new data file (call it
Filtered_AL_Weather_Station.txt ) that omits those records with bad
data flags. This new file will be used in problem 2. NOTE: The
temperatures are given in tenths of a degree Celsius. e.g 83 is 8.3
degrees C.
2. Using the filtered data...
1.) The file cats.csv contains a data set consisting of the body weight (in kilograms) and...
1.) The file cats.csv contains a data set consisting of the body
weight (in kilograms) and heart weight (in grams) for 12 cats. Give
the estimated regression line using the body weight as the
predictor variable (x-variable) and the heart weight as the
response variable (y-variable). Also, provide interpretations in
terms of the problem for the slope and the y-intercept.
2.) The file cats.csv contains a data set consisting of the body
weight (in kilograms) and heart weight (in grams)...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- The following information is available for Robstown Corporation for 20Y8: Inventories January 1 December 31 Materials...
- /* Complete the TO DO comments below */ window.onload = function() { /* TODO add a...
- Trevor Price bought 10-year bonds issued by Harvest Foods five years ago for $4,532.35. The bonds...
- How do you represent 5.1 (5 + 1/10) in binary? I know that it is 0101....
- More and more adults are considering commuting to work by bicycle rather than car, but few...
- Please answer these questions Data Processing and Analysis using python. Thank you In statistics, an outlier...
- Write a function file that accepts each of the four vectors as inputs. The function file...
ADVERTISEMENT