You just finished teaching your first PSYCH 248 lab section, and it’s time to calculate the grades. Your wonderful teaching assistant created an Excel file with all of the students’ exam grades, homework grade, and lab grade as well as their gender. Your next steps are to calculate each student’s final grade, convert those scores to letter grades, and describe the distribution of scores. Data Management Steps:
You just finished teaching your first PSYCH 248 lab section, and it’s time to calculate the grades. Your wonderful teaching assistant created an Excel file with all of the students’ exam grades, homework grade, and lab grade as well as their gender. Your next steps are to calculate each student’s final grade, convert those scores to letter grades, and describe the distribution of scores. Data Management Steps:
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Background: You just finished teaching your first PSYCH 248 lab section, and it’s time to calculate the grades. Your wonderful teaching assistant created an Excel file with all of the students’ exam grades, homework grade, and lab grade as well as their gender. Your next steps are to calculate each student’s final grade, convert those scores to letter grades, and describe the distribution of scores.
Data Management Steps:
1. Download the CA1_Dataset.csv file from Blackboard.
2. In Excel, calculate the final Number Grade, Letter Grade, and Z-score for each student.
a. To calculate the Number Grade, type a numerical equation after an = sign in a cell or use the =AVERAGE() formula; however, keep in mind that the =AVERAGE() formula will always give you the regular mean, not the weighted mean. Grades for this course are comprised of three parts: lecture exams (60%), homework (20%), and lab (20%).
b. To calculate the Letter Grade, use the =IF() formulawith a series of logic statements or enter the data by hand. For this assignment, let’s convert Number Grade into Letter Grade using the following rubric: A (90-100), B (80-89), C (70-79), D (60-69), F (<60).
c. To calculate the Z-score, use the =STANDARDIZE() formula on the Number Grade variable. This formularequires three components: x (i.e., one student’sNumber Grade), the sample mean, and the sample standard deviation. You can calculate the sample mean and standard deviation for Number Grade using the =AVERAGE() and =STDEV() formulas.
i. Create a new column called Abs(Z-score). In this column, use the =ABS() formula on the Z-score variable you just created to get the absolute values of each Z-score.
3. Now that you have filled in your dataset, save your file and open it in JASP.
a. In the Data View, apply value labels to the Gender variable by clicking on the title of the column and entering the labels accordingly (0=Woman, 1=Man).
b. Make sure that each variable has the correct “column type” (i.e., nominal, ordinal, or scalar).
5. Frequencies
a. How many women were in the class?
b. Paste the frequency table that shows this data below.
6. Percentages
a. What percentage of the class identified as men?
b. How is the Valid Percent column different from the Percent column?
7. Distribution Plots
a. For the Number Grade variable, create a Distribution Plot and apply a density curve. Paste the graph below.
b. Does this plot appear to be fairly normal?
8. Normality/Skewness
a. What is the skewness value for the Number Grade variable?
b. Does this mean the distribution of Number Grades is normal or skewed? Why?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman