Reference no: EM131304599

Objective: Create an Excel Spreadsheet with basic charts

Create the following spreadsheet and charts:

1. Create the worksheet above

• a. Name it CSCIN207.
• b. Save your spreadsheet as CSCIN207Grades15-16.xlsx

2. Create a single pie chart

• a. Use the total for all three semesters (you will need to add another column to your worksheet to hold the total.  
• b. Make the chart 3-D. 
• c. Title it CSCI N207 Grades 2015-2016
• d. Place the chart on the same worksheet.

3. Create single 3-D bar chart

• a. Display the above data (there should be 3 bars for each grade).  
• b. Move the chart to a separate worksheet and name the sheet 3DBarChart
• c. Make the title CSCI N207 Grades By Semester

Below is grade data for a previous semester of this class:

Midterm Exam	Final Exam
73	62
60	87
78	84
100	93
76	62
73	89
54	69
94	100
69	82
61	86
79	100
85	78
49	77
100	97
88	93
79	75
94	90
67	69
74	83
61	29
85	66
79	97
86	71
100	100
97	98
64	73
67	100
60	9
53	41
73	85
88	79
70	55
74	41
93	92
74	75
97	100
94	97
39	23
71	46
86	82
89	72
94	77
60	88
68	40
34	23
85	65
91	93
97	61
53	54
73	52
91	78

 

Create the following spreadsheet and charts:

1. Create the worksheet above

• a. Name it Spring2016Grades.
• b. Save your spreadsheet as CSCIN207Spring2016.xlsx

2. Create a scatter plot (show the linear trend line)

• a. Title the scatter plot Spring 2016 Grades
• b. Save the plot to a separate sheet named ScatterPlot

3. On the Spring2016worksheet do the following analysis, make sure to format appropriately:

• a. What is the minimum, maximum, mean and median score for the Midterm.
• b. What is the minimum, maximum, mean and median score for the Final Exam
• c. What is the standard deviation of the midterm exam? 
• d. What is the standard deviation of the final exam?
• e. What is the correlation between the midterm exam and the final exam?

To turn in class:Printouts for the spreadsheets. Please make sure you have all assignments labeled, include in the sequence shown below and stapled together and please include a cover page.

1. Worksheet CSCIN207 printout that includes the data and Pie chart.  Label it #1
2. Bar chart printout. Label it #2
3. Worksheet Spring 2016 Grades only include the data (use a selection to print).  Label it #3
4. Printout of analysis of data: standard deviation, correlation(use a selection to print).  Label it #4
5. Scatter plot printout. Label it #5