EXERCISE 1

Materials:

Device with Installed MS Excel

Activity:

Answer the following questions. Show necessary solutions.

1) Explain "Survey is to sample, as census is to population."

2) What kind of sampling will you use if you have a population of 100? Explain why.

3) Miller, et al. (2008) conducted a study on the "Development and Implementation of a Ballpen and Bondpaper CRRM Machine for University of Michigan They planned to implement it on the VNM and Junior Building of the school. This will cater all students from the Junior High School, School of Psychology, and the School of Education. Before the conduct of the study, they had a survey first to support their claims on the feasibility of the study. They asked a headcount of students from the Office of the Registrar. The registrar gave the following data:

School

No. of Students

Junior High School 535

School of Pyschology 191

School Of Education 62

The researchers utilized stratified random sampling using Raosoft.com and MS Excel. How do you think was their distribution of respondents? Verify it using Raosoft.com and MS Excel.

4) Think for a study you want to conduct. What type of sampling technique will you use? Explain.

EXERCISE 2

Device with MS Excel

Activity:

Perform the following. Answer the following questions. Show all necessary solutions.

1) The following are list of scores in an statistics exam:

65 76 87 96 85 74 63 55 92 92 93 58 90 93 100 53 50 83 82 75 82 84 90 79 78 79 67 56 57 76 84 84 72 86 72 95 92 76 83 86 92 92 83 63 60 50 59 58 76 74 72 94 92 48 82 89 88 75 76 68 89 76 87 54 98 95 55 50 64 83 85 82 94 73 83 96 77 75 88 66 93 93 59 85 93 84

Make a grouped frequency distribution table for these scores using MS Excel.

2) Illustrate the results in charts using MS Excel.

3) What are the advantages of having computer applications such as MS Excel for statistical analysis?

4) Aside from the discussed method of creating a FD Table in Excel, are there any other methods to do it in Excel? How?