1.Excel file Traveler contains months of the year and number of travelers that arrive in morning (AM) and the evening (PM). Prepare a line chart showing the number of AM and PM travelers fpr each month. (2)

2.Excel file Facebook Survey provides data gathered from a sample of college students. Create a scatter chart showing relationship between hours online/week and friends.(3)

4. Excel file Internet usage provides data about users of the internet. Construct stacked bar charts that will allow you to compare any differences due to age or education attainment and draw any conclusions that you can. Would another type of chart be more appropriate? (7)

5. Convert the Store and Regional Sales database to an excel Table. Use Table based calculations to find :

1. Total number of units sold
2. The total number of units sold in the southern region
3. Total number of units sold in December (13)
4. 

6. Convert Purchases Orders Database to an excel table. Use Table based calculations to find:

1. Total cost of all orders
2. Total quantity of Airframe fasteners purchased
3. The total cost of all orders placed with Manley Valve. (14)
4. 

7. The Total number of runs scored by 30 players in a test cricket match in 2011 were recorded to determine which score was highest and which was lowest

The Runs are:

423, 369, 411, 387, 393, 394, 371, 377, 389, 409, 392, 408, 431, 401, 363, 391, 405, 382, 400, 381, 399, 415, 428, 422, 396, 372, 410, 419, 386, 390

Construct a frequency distribution table and calculate the relative frequency.(16)
 
 
 
 
 

File Paste Clipboard F4 AEG 95998 AutoSave Off H A 2 JANUAR 3 FEBRUA 4 MARCH 5 APRIL 6 MAY 7 JUNE 8 JULY 9 AUGUST 10 SEPTEM 11 OCTOBE 14 15 12 NOVEM 13 DECEMB 16 18 20 21 22 23 LB- 4 A 6000 19 3000 5000 4000 Home Insert Page Layout 2000 1000 0 F Calibri BIUY B X 1000 1200 1400 2000 3000 1500 1000 2000 4000 5000 4500 2000 Font v C Type here to search fxx 11 A A Y 800 2000 3000 5000 1000 900 1600 1900 1300 1400 1500 2500 V A D Formulas Data 3-2 3-3 3-4 3-5 3-6 Traveler database - F == = E F + -AM Traveler -PM Traveler Review View Alignment O ab e G i Search H Help Wrap Text Merge & Center E 5 General I Y 1 %9-00 .00 Number O Conditional Format as Cell Formatting Table Styles Styles K Average: 2145.833333 X L Insert Insert Delete Format Cells Count: 39. WB S... Sum: 51500 alhaji jalloh AJ M 27 0 4 Ideas Sort & Find & Filter Select Editing B N Share W Ideas 0 Sensitivity O Comments Sensitivity X 10:55 05/11/2020 ^ V A + 100%