1.Excel file Traveler contains months of the year and number of travelers that arrive in morning (AM)...
Question:
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 :
- Total number of units sold
- The total number of units sold in the southern region
- Total number of units sold in December (13)
6. Convert Purchases Orders Database to an excel table. Use Table based calculations to find:
- Total cost of all orders
- Total quantity of Airframe fasteners purchased
- The total cost of all orders placed with Manley Valve. (14)
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)
Financial Accounting An Introduction to Concepts, Methods and Uses
ISBN: 978-1133591023
14th edition
Authors: Roman L. Weil, Katherine Schipper, Jennifer Francis