1. The prices of 20 different mobile devices is given below

(Price in INR)

19,500 10,000 8,000 5,000 25,000
35,000 7,000 16,000 24,000 29,000
31,000 9,000 21,500 16,000 11,000
42,000 4,000 27,000 14,000 13,000

Perform the following tasks for the given data:

Enter the data in a spreadsheet package and create frequency distribution in the ranges: less than 5,000; 5,001 to 15,000; 15,001 to 25,000; 25,001 to 35,000; Above 35,000. You must use array formula for this frequency distribution.

Draw the histogram of the data.

Find the mean and variance for the data using spreadsheet formulae/functions.

Find the maximum and minimum of price using spreadsheet formulae/functions.

2. Consider the following data

Rainfall Data

Year Rainfall in mm
2001 1050
2002 920
2003 1500
2004 1250
2005 1600
2006 800
2007 900
2008 1100
2009 1500
2010 1200

Find the moving averages of length 3 and 5. Plot these moving averages using spreadsheet.