May I have samples on how to answer the attached files? No idea yet.

Thank you.

M' nLlnE @ 0 Education ' OEd Quantltative Method Levels of Measurement Week003-Levels of Measurement Laboratory Exercise 001 Objective/s: At the end of this activity, you should be able to: o Create spreadsheet file; 0 Compute for the frequency of the data per category; and o Formulate a conclusion or analysis about the experiment. What to Prepare for the Activity: 0 Microsoft Excel or Spreadsheet/SPSS 0 Pencil and paper Procedure: 1. Load Microsoft Excel or any electronic spreadsheet. Enter the data from the table below. 2. Compute the frequency ofall nominal variables by category using the =COUNIFO function. You can use the =countif() by supplying the range and the criteria. For example, to determine the frequency of number of 1's from Bl to B30, use =COUNTIF(BI:B30, "=1\") Make another table for the results and create a graph 4. Transfer the results in Microsoft Word Application. Give your interpretation to the results. Use the given format Format: introduction Survey Results and Discussions Table and Graph Interpretation Conclusion .W Assessments A study was conducted on the achievement between male and female to determine ifthere is significant difference between nominal variables (gender, sibling, parent style) and their achievement.The result of the survey is presented in the table Gender Age Sibling ParentStyle Achievement '_ 12 1 2 79 '_ 13 2 1 81 '_ 13 1 1 83 '_ 13 3 1 86 '_ 12 3 1 86 1 13 2 1 82 '_ 13 1 1 78 '_ 13 4 2 81 '_ 13 3 2 83 '_ 13 3 3 77 '_ 14 2 3 79 '_ 13 2 1 81 1 12 1 1 75 '_ 12 1 1 79 '_ 13 3 1 90 '_ 15 3 3 80 '_ 15 3 1 79 '_ 14 2 1 84 '_ 15 3 1 75 '_ 14 2 1 81 '_ 13 4 1 79 '_ 14 1 1 79 '_ 14 1 3 87 '_ 14 3 1 82 '_ 14 3 1 90 1 15 1 1 84 '_ 14 3 1 82 '_ 15 1 2 87 '_ 15 4 1 91 56%: onLlnE ' OEd Quantitative Method Education Levels of Measurement Manual Computation Show the Frequency Distribution Table of the list of IQ scores for a gifted classroom in a particular dernentaryschoolvvhlithe lovvhlgilata:118,123,124,125,127,128,129,130,130,133,136,138, 141,142,149,150,154. Step-by-step Solutions: Part 1: Choosing Classes Step 1: Figure out how many classes (categories) you need. There are no hard rules about how many classes to pick, but there are a couple ofgeneral guidelines: Pick between 5 and 20 classes. For the list oles above, we picked 5 classes. Make sure you have a few items in each category. For example, if you have 20 items, choose 5 classes (4 items per category), not 20 classes (which would give you only 1 item per category). Part 2: Sorting the Data Step 2: Subtract the minimum data value from the maximum data value. For example, our IQ list above had a minimum value of 118 and a maximum value of 154, so: 154 118 = 36 Step 3: Divide your answer in Step 2 by the number of classes you chose in Step 1. 36/5=7.2 Step 4: Round the number from Step 3 up to a whole number to get the class width. Rounded up, 7.2 becomes 8. Step 5:Write down your lowest value for your first minimum data value: The lowest value is 118 Assessments Step 6:Add the class width from Step 4 to Step 5 to get the next lower class limit: 118+8=126 Step 7: Repeat Step 6 for the other minimum data values (in other words, keep on adding your class width to your minimum data values) until you have created the number of classes you chose in Step 1. We chose 5 classes, so our 5 minimum data values are: 118 126 (118 + 8) 134 (126 + 8) 142 (134 + 8) 150 (142 + 8) Step 8: Write down the upper class limits. These are the highest values that can be in the category, so in most cases you can subtract 1 from the class width and add that to the minimum data value. For example: 118 + (8 1) = 125 118 125 126 133 134 141 142 149 150 157 3. Finishing the Table Up Step 9: Add a second column for the number of items in each class, and label the columns with appropriate headings: IQ NUMBER 118-125 126-133 134-141 142-149 % onLlnE ' 06d Quantitative Method Education Levels of Measurement 150-157 Step 10: Count the number ofitems in each class, and put the total in the second column. The list ()le scores are: 118, 123,124, 125, 127,128, 129, 130,130,133, 136, 138,141, 142,149, 150, 154. [Q NUMBER 118-125 4 126133 6 134-141 3 142-149 2 150157 2 Rubric for Checking Criteria for Evaluation: Appropriateness of statistical tests and accuracy in the computation (10%) Analysis and interpretation (10%) Presentation, technical tone, format (5%) Take note ofthe equivalent grade: 1.0 24-25 1.25 21-23 1.5 18-20 1.75 15-17 Assessments