The marks obtained by 20 students in an entrance examination out of 100 are given below:
60, 50, 75, 25, 80, 35, 85, 60, 65, 95, 31, 91, 71, 68, 25, 30, 62, 73, 77, 64
Using a spreadsheet package, perform the following tasks:
a) Enter the data in a spreadsheet.
b) Create a frequency distribution using class intervals: 0–10, 11–20, 21–30, …, 91–100.
c) Draw a histogram for the data.
d) Calculate the mean and standard deviation using spreadsheet formulas.
e) Find the minimum and maximum marks.

The pulse rates of 6 people were recorded before and after taking a new drug:
Before: 69, 72, 67, 75, 80, 79
After: 70, 68, 68, 71, 72, 75
Using a spreadsheet package, perform a paired t-test at 10% level of significance to test whether the drug
causes a significant decrease in pulse rate.

The pulse rates of 6 people were recorded before and after taking a new drug:
Before: 69, 72, 67, 75, 80, 79
After: 70, 68, 68, 71, 72, 75
Using a spreadsheet package, perform a paired t-test at 10% level of significance to test whether the drug
causes a significant decrease in pulse rate.

 Create a frequency distribution using the class intervals:
 0–25, 26–50, 51–75, 76–100, 101–125, 126–150, 151–175, 176–200.
b) Use an array formula or suitable spreadsheet function to count frequencies.
c) Draw a histogram.
d) Calculate the mean and variance.
e) Find the lowest and highest project marks.

The marks of 20 students in a project course out of 200 are given below:
110, 95, 150, 80, 115, 30, 180, 125, 90, 117, 25, 75, 85, 135, 160, 77, 89, 129, 149, 101
Using a spreadsheet package, perform the following tasks: