Critical Thinking Assignment part 2
Fall 2020
Critical Thinking Assignment: Data Analysis Part 2 (50 points)
DUE DATE: OCTOBER 28
INSTRUCTIONS:
Using your sample data obtained from the student survey and using Microsoft Excel or your TI-84 calculator, fill in the values in the table below.
Table 1: Students with no dependents
Age
GPA
TCH comp
HRS per/wk
CRSE anxiety
CRSE difficulty
HRS ON HOMEWORK
MEAN
MEDIAN
MODE
STD DEVIATION
VARIANCE
Q1
Q2
Q3
IQR
LIST ANY OUTLIERS
Table 2: Students with dependents
| Age | |
1.
Compare the mean and standard deviation using the variable Age for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean age of ___ and a standard deviation of ____
Students with no dependents had a mean age of _____ and a standard deviation of _____
Age Comparison
GROUPS
Students with Dependents
Students with no Dependents
MEAN
STD DEV
Construct a boxplot for each group to show the distribution of ages using Excel.
2. Compare the mean and standard deviation using the variable GPA for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean GPA of ____ and a standard deviation of _____
Students with no dependents had a mean GPA of ___ and a standard deviation of ____
GPA Comparison
GROUPS
Students with Dependents
Students with no Dependents
MEAN
STD DEV
Construct a boxplot for each group to show the distribution of GPA using Excel
3. Compare the mean and standard deviation using the variable Total Credit Hours Completed for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean total credit hour completed of ____and a standard deviation of ___
Students with no dependents had a mean total credit hour completed of _____ and a standard deviation of _____
Total Credit Hours Completed Comparison
GROUPS
Students with Dependents
Students with no Dependents
MEAN
STD DEV
Construct a boxplot to show the distribution of total credit hours completed for each group using Excel
4. Compare the mean and standard deviation using the variable Hours work per week for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean hour work per week of ____and a standard deviation of ___
Students with no dependents had a mean hour work per week of _____ and a standard deviation of _____
Hours work per week comparison
GROUPS
Students with Dependents
Students with no Dependents
MEAN
STD DEV
Construct a boxplot to show the distribution of hours work per week for each group using Excel
5. Compare the mean and standard deviation using the variable Course Anxiety for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean anxiety of __ and a standard deviation of __
Students with no dependents had a mean anxiety of ____ and a standard deviation of __
Course Anxiety comparison
GROUPS
Students with Dependents
Students with no Dependents
MEAN
STD DEV
Construct a boxplot to show the distribution of anxiety for each group using Excel
6. Compare the mean and standard deviation using the variable Course Difficulty for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean course difficulty of _ and a standard deviation of _
Students with no dependents had a mean course difficulty of ____ and a standard deviation of _____
Course Difficulty comparison
GROUPS
Students with Dependents
Students with no Dependents
MEAN
STD DEV
Construct a boxplot to show the distribution of course difficulty for each group using Excel
7. Compare the mean and standard deviation using the variable Hours spent on homework for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean hour on homework of _____ and a standard deviation of _____
Students with no dependents had a mean hour on homework of _____ and a standard deviation of _____
Hours spent on homework comparison
GROUPS
Students with Dependents
Students with no Dependents
MEAN
STD DEV
Construct a boxplot to show the distribution of hours on homework for each group using Excel