Hi, is there anybody who can help me these (see attached)?

Thank you!

Week003Levels of Measurement Laboratory Exercise 001 Objective / 5: At the end of this activity, you should be able to: o Create spreadsheet le; 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 of all nominal variables by category using the =COUNIF() 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 B1 to B30, use =COUNTIF(Bl: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 A study was conducted on the achievement between male and female to determine if there is significant difference between nominal variables (gender, sibling, parent style) and their achievement.The result of the survey is presented in the table ParentStyle Achievement Gender Age Sibling 79 1 12 1 2 81 13 IN 83 1 13 1 86 W 13 86 12 1 82 1 13 2 78 13 2 81 13 83 13 77 W W N 79 - P P 14 81 13 75 12 79 12 W N W W W H H N N W W 90 13 HWHY 80 15 79 15 84 14 75 15 81 14 N 79 13 79 14 87 14 82 - W W H H 14 90 14 84 - P 15 82 14 87 N 15 91 15 4Manual Computation Show the Frequency Distribution Table ofthe list of IQ scores for a gifted classroom in a particular elementary school With the following data: 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 of general guidelines: Pick between 5 and 20 classes. For the list of IQs 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 rst minimum data value: The lowest value is 118 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 125 (118 + 8) 134 (125 + 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 + (3 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 150157 Step 10: Count the number of items in each class, and put the total in the second column. The list ofIQ scores are: 113, 123, 124, 125, 127, 128, 129, 130, 130, 133, 136, 138, 141, 142, 149, 150, 154. [Q NUMBER 118-125 4 126-133 6 134-141 3 142149 2 150-157 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 of the equivalent grade: 1.0 24-25 1.25 21-23 1.5 18-20 1.75 15-17