Lab 2: Spreadsheets: Microsoft Excel
At least one of following videos should be watched on Blackboard before your lab period:
1. Introduction to the Excel User Environment. http://bit.ly/1NaGbzg
2. Formulas. https://www.youtube.com/watch?v=wqn7mxR2Xpk Additional information on formulas is at: https://www.youtube.com/watch?v=-kNiQGgTYK4 and https://support.office.com/en-us/article/Overview-of-formulas-in-Excel-ecfdc708-9162-49e8-b993-c311f47ca173
3. Functions and Graphs. https://www.youtube.com/watch?v=DM52xjSLGqs
Note that if you still have questions about using Microsoft Excel, you could search YouTube (or otherwise Google) for more how-to videos. This site:
has a good set of tutorials for all Office products.
This assignment should be submitted in an Excel file (Lab02_LastNameFirstInitial.xlsx) to Blackboard with four separate tabs, each corresponding to one question. The tabs should be labeled accordingly and should include a presentation of the raw data as shown in each question and of the graphics and information requested. Be sure to include any explanations as necessary (for example, what features of Excel were necessary to get the job done?).
Graph the following enrollment data using a pie chart. Be creative with your pie chart. It should have a title, appropriate labeling and should be visually attractive while informative. The original tabular data should also be attractively presented.
Graph the following income data using a column graph. As with the above graph, this graph should have a title, appropriate labeling and should be visually attractive while informative. The original tabular data should also be attractively presented.
Create a table showing the relationship between D and V for the following values: d = 0.25, n = 2, dp = 0.5, C = 5, and q = 45Â°, using the relationship shown below. Remember that you must convert to radians when using trigonometric functions in Excel. Also, create an xy plot of this relationship. Make sure to include appropriate titles, labels, etc., and to make everything visually pleasing.
Using the rainfall data shown in the table shown below, create an xy plot then find a trendline that works best. You should submit your plot and the equation and R2 of your trendline.
a) Watched at least one of the videos â€“ 5
b) A separate tab included for each problem â€“ 8
c) Input data and output data are both included â€“ 8
d) Accurate â€“ 8
e) Aesthetically pleasing â€“ 8
f) File named â€œLab02_LastNameFirstInitial.xlsxâ€ – 3