Ass1 Excel

Assignment#1

Problem 1:

Table 1 contains data for the number of pedestrians that were killed in the United States in 1994 in motor vehicle crashes.

Table 1:

Perform the following procedures in Excel.
1. Create an Excel file with the above data (worksheet’s name is “Pedestrians”).
2. Calculate the total number of pedestrian fatalities that occurred during weekdays. Calculate the percent of all weekday fatalities that occurred during each of the given times of day.
3. Calculate the total number of pedestrian fatalities that occurred during weekends. Calculate the percent of all weekday fatalities that occurred during each of the given times of day.
4. Calculate the total number of fatalities that occurred during each time of day (i.e., add weekday and weekend fatalities for each time of day). Calculate the percent of all pedestrian fatalities that occur during each time of day (weekdays and weekends combined).
5. Format your percentage data so that percentage signs and only one decimal place is shown.
6. Use Conditional Formatting to highlight the time of the day that has the highest and the lowest numbers of pedestrian fatalities for the weekday, the weekend, and the total.
7. Create a bar graph for the percent of all fatalities by the time of day
8. Describe the results e.g. the most dangerous times of day and the least dangerous times of day for pedestrians, etc.
9. Save your Excel document with the file name xxx (your name) and email it to me.

Problem 2:
Table 2 shows the grades for ECON 101 Spring 2013 class.

Last name
First name
Exam 1
Exam 2
Exam 3
Paper
Participation
Stevens,
Tony
64
70
73
85
75
Rivers,
Tina
70
77
88
95
90
Beal,
Jenny
77
83
79
88
80
Calhoun,
Richard
69
43
81
78
75
Nixon,
Rachel
91
90
86
95
88
Freeman,
Ralph
44
26
54
78
80
Copely,
Roy
61
67
70
85
80
Kimmett,
Roger
77
85
86
85
85
Allen,
Renae
83
86
92
85
88
Victor,
Isaac
97
80
82
85
88
Albright,
Alan
69
69
50
85
75
Bredder,
Richard
96
92
92
98
85
Gaby,
Brad
95
89
89
95
85
Hendrix,