AutoSave . Off 19 - B Lab5ca_CA1_Assignment Descriptives - O Luis Rodriguez LR X AutoSave O Off Lab5ca_CA1_Dataset_Descriptives . O Luis Rodriguez LR File Home Insert Design Layout References Mailings Review View Help Share Comments File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri (Body) 12 O Calibri 11 General Conditional Formatting Insert BIUabX X A BIU AA E $ ~ % 9 Format as Table Delete Paste Styles Editing Dictate Editor Reuse Paste Analyze A L Av Aa A A Files $58 308 Cell Styles Format Data Clipboard Font Paragraph Styles Is Voice Editor | Reuse Files Clipboard Font Alignment Number Styles i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Angelo Orosco CZ X V 61 PSYCH 248.01L5 Computer Assignment #1 4 B D E G H K X Angelo Orosco ID NumberGender (0 Exam 1 Exam 2 Exam 3 Homewor Lab Number G Letter Gra Z-Score Name: Date: 94 87 100 89 Background: You just finished teaching your first PSYCH 248 lab section, and it's time to 87 calculate the grades. Your wonderful teaching assistant created an Excel file with all of the 94 students' exam grades, homework grade, and lab grade as well as their gender. Your next steps 97 are to calculate each student's final grade, convert those scores to letter grades, and describe 90 the distribution of scores. 68 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() formula with 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 (