The max grade for this lab is 120 but the scale is still 100 points. The extra 20 points is extra credit.

Open File:US_Crime, and produce a chart ofColoradowith X and Y coordinates beingBurglaryandMurdercounts, respectively.

Answer questions 1 to 4.(pick the answer that fits best)

1. Which kind of trend do you observe?

• a. No trend
• b. Negative
• c. Positive

2. Is this trend (or lack of trend) expected?

• a. Yes
• b. No
• c. Not enough information to decide

3. Does this trend mean that as we observe more burglaries we also observe more murders?

• a. No
• b. Yes

4. What does each dot represent on this chart?

• a. A year
• b. A state
• c. A decade
• d. A murder

Tutorial

Upload data:Smokingand open the data in Excel by following from Lecture 2 and 4.

Figure 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

Use theMileagedata and chart with X and Y coordinates beingCar mileage in thousandsandCar gas mileage in miles per gallon, respectively. In addition add thetrendlineand itsequationon the chart.

Hint: 1) To put in the equation left click anywhere on the chart and look for the following

PLUSsign at the upper right corner:

2) Click on the PLUS sign, then on the Trendline and then on the arrow sign next to it and choose: More Options.

3) A bigger window will prompt up (picture below). Since the default setting is for Linear trend you only need to click on Display Equation part.

5. Which kind of trend do you observe?

• a. Positive
• b. Negative
• c. No trend

6. Is this trend (or lack of trend) expected?

• a. Yes
• b. No
• c. Not enough information to decide

7. What is the slope of the line?

• a. 0.0833
• b. -0.0833
• c. -0.0833x
• d. 48.786

8. Given the data what is the interpretation of the number 48.786? (pick ONE answer that fits the best):

• a. The number is meaningless in this setting.
• b. It tells us that the older the car the worse the gas mileage.
• c. It tells us the gas mileage for a new car.
• d. It is the X-intercept.

Use theFliers Customersdata and chart with X coordinates being number ofFliersthat the restaurant manager distributed weekly and Y coordinates being number of weekly restaurantCustomers. In addition add thetrendlineand itsequationon the chart.

Answer questions 9 to 12.(pick the answer that fits best)

9. Which kind of trend do you observe?

• a. No trend
• b. Positive
• c. Negative

10. Is this trend (or lack of trend) potentially good news regarding increasing the restaurant profits?

• a. No
• b. Yes

11. What is the slope of the line?

• a. 0.338
• b. 0.338x
• c. 0.2297
• d. 0.2297x

12. Given the data what is the interpretation of the number 315.48? (pick ONE answer that fits the best):

• a. The number is meaningless in this setting.
• b. It tells us the restaurant would expect on average about 315 customers weekly even if no fliers were distributed weekly.
• c. It tells us the more fliers being distributed the weekly number of restaurant customers will increase by about 315.
• d. It tells us the restaurant profit will increase by about $315 even if no fliers were distributed weekly.