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: 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) Questions Boxplots a. Create boxplots for Number Grade separately for men and for women; make sure to label outliers. Paste your boxplots below. b. Is there more variability in the distribution for men or for women? How can you tell? 12. Outliers a. In the boxplot you created for the questions above, how many outliers are there? b. What do the numbers next to each outlier dot stand for? 13. Percentiles a. When looking at the whole sample, what value corresponds to the 70th percentile for the Homework variable? b. What does scoring in the 70th percentile mean? 14. Z-Scores a. How many Number Grades have an absolute Z-score of 2 or higher? b. What Letter Grade coincides with having a Z-score of -2 or lower? 15. Transforming Numerical Data to Categorical Data a. How many A’s did students receive in your class? What percentage of the class received B’s? b. Paste the frequency table you used to answer the above question below

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: 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) Questions Boxplots a. Create boxplots for Number Grade separately for men and for women; make sure to label outliers. Paste your boxplots below. b. Is there more variability in the distribution for men or for women? How can you tell? 12. Outliers a. In the boxplot you created for the questions above, how many outliers are there? b. What do the numbers next to each outlier dot stand for? 13. Percentiles a. When looking at the whole sample, what value corresponds to the 70th percentile for the Homework variable? b. What does scoring in the 70th percentile mean? 14. Z-Scores a. How many Number Grades have an absolute Z-score of 2 or higher? b. What Letter Grade coincides with having a Z-score of -2 or lower? 15. Transforming Numerical Data to Categorical Data a. How many A’s did students receive in your class? What percentage of the class received B’s? b. Paste the frequency table you used to answer the above question below

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Data Management Steps:

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)

Questions

Boxplots

a. Create boxplots for Number Grade separately for men and for women; make sure to label outliers. Paste your boxplots below.

b. Is there more variability in the distribution for men or for women? How can you tell?

12. Outliers

a. In the boxplot you created for the questions above, how many outliers are there?

b. What do the numbers next to each outlier dot stand for?

13. Percentiles

a. When looking at the whole sample, what value corresponds to the 70th percentile for the Homework variable?

b. What does scoring in the 70th percentile mean?

14. Z-Scores

a. How many Number Grades have an absolute Z-score of 2 or higher?

b. What Letter Grade coincides with having a Z-score of -2 or lower?

15. Transforming Numerical Data to Categorical Data

a. How many A’s did students receive in your class? What percentage of the class received B’s?

b. Paste the frequency table you used to answer the above question below.

Below is the transcription of a data table that could be used on an educational website. The table provides a summary of students' performance across various assessments.

| ID Number | Gender (0=Woman, 1=Man) | Exam 1 | Exam 2 | Exam 3 | Homework | Lab | Number Grade | Letter Grade | Z-Score |
|-----------|-------------------------|-------|-------|-------|----------|-----|--------------|-------------|---------|
| 0 | 0 | 61 | 94 | 76 | 94 | 87 | | | |
| 2 | 0 | 99 | 97 | 90 | 100 | 89 | | | |
| 3 | 0 | 64 | 76 | 69 | 88 | 87 | | | |
| 4 | 0 | 77 | 82 | 86 | 98 | 94 | | | |
| 5 | 0 | 70 | 89 | 81 | 93 | 97 | | | |
| 6 | 0 | 67 | 62 | 65 | 60 | 90 | | | |
| 7 | 0 | 87 | 83 | 81 | 85 | 68 | | | |
| 8 | 0 | 74 | 88 | 65 | 49 | 90 | | | |
| 10 | 0 | 94 | 87 | 77 | 90 | 67 | | | |
| 11 | 0 | 47 | 72 | 54 | 59 | 63 | | | |
| 12 | 0 | 81 | 64 | 78 | 84 | 73 | | | |
| 13 | 0 | 87 | 90 | 81 |

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 3 images

SEE SOLUTION Check out a sample Q&A here