# Lab 3.docx - Lab 3 Task 1 The max grade for this lab is 120...

• Lab Report
• 12
• 84% (19) 16 out of 19 people found this document helpful

This preview shows page 1 - 4 out of 12 pages.

Lab 3 / Task 1 The max grade for this lab is 120 but the scale is still 100 points. The extra 20 points is extra credit. Open File: Cars04 , and produce a chart with X and Y coordinates being Length and City MPG , respectively. Answer questions 1 to 4. (pick the answer that fits best) 1. Which kind of trend do you observe? ď‚· a. Positive ď‚· b. Negative Correct Answer
ď‚· c. No trend 2. Is this trend (or lack of trend) expected? Correct Answer
ď‚· c. Not enough information to decide 3. Does this trend mean that City MPG increases with car length? Correct Answer
4. What does each dot represent on this chart? Correct Answer
ď‚· c. Length ď‚· d. City MPG Tutorial Upload data: Smoking and open the data in Excel by following from Lecture 2 and 4. Fig ure 6.1 Use the â€ścosmeticâ€ť steps from Lecture 4 in order to produce the chart as presented on Figure 6.1 above. The only novelty is the trend line and here is how to create it: Left click anywhere on the chart and look for the following PLUS sign at the upper right corner: Click on the PLUS sign and several options will appear: Chart Elements: Axis, Axis Title, Chart Title...Trendline.
Click on box for Trendline. If the PLUS trick does not work, Right Click on any dot -> A window will prompt -> Click on Add Trendline and follow the prompts. Here is video link as well: Trend Line Lab 3 / Task 2 Use the SAT data and create a chart with X and Y coordinates being High School GPA and SAT , respectively. In addition add the trendline and its equation on the chart.