1. The average temperatures of 20 different locations were recorded in a table. This data is as follows

(Temperature in
35 11 2 17 40
25 17 29 33 37
15 19 28 38 31
18 24 27 35 40

Perform the following tasks for the data given above:

Enter the data in a spreadsheet and create a frequency distribution in the ranges below 6° to 15°C; 16° to 25°C; 26° to 35°C; 36° to 45°C; above 45°C. Use array formula for finding the frequency distribution.

Draw the histogram of the data.

Find the mean and standard deviation for the "data using spreadsheet formulae/functions.

Find the minimum and maximum temperature using spreadsheet formulae/functions.

2. To find a relationship between age and height, an NGO collected the following data:

Age in years Height in cms

9 135
7 127
3 100
5 125
6 120
8 137
2 95
7 135

Construct a scatter plot (diagram) for the given data using a spreadsheet package.

Find the best linear regression line assuming that age is the dependent variable and height is the independent variable.