Acdtivity 2.1 screen shots included, need help mainly with 1 through 7 only. if you could help with all of 2.1 that would be great but if not I just need these parts of 2.1(ehicfh you will also see in the screenshot) This is for QRB/501 Acdtivity excel workbook 2.

Activity 2.1 at least the first #s 1 to 7, or anythng you can help with please.

 Attachment has screenshot which is more descriptive, Zoom 200% it reads clear and easier to see.

Estimating Dates: Scatterplots

In this activity, you will estimate the dates of several major events and then use a scatterplot to compare your estimates with the actual dates these events occurred. You will analyze relationships between two variables that can be read from a scatterplot.

You will start with an estimation experiment. Work with one or two classmates and fill in the following table, giving your group’s best estimate of the year in which each event occurred.

For each of the following twentieth century events, estimate the year in which the event occurred. (Record only the last two digits of the year; because you know all dates are in the 1900s, you don’t need to record the “19.”)

Event Estimated Year Event Occurred

Oprah Winfrey born

Martin Luther King assassinated

Original Woodstock music festival held

Event Estimated Year Event Occurred

Nineteenth amendment established women’s suffrage

The World Wide Web developed

YEAR EVENT OCCURRED – IN ORDER

54

68

69

19

1

89

Oprah 26

41

30

82

41

74

93

6

Web 91

Obtain the actual dates for those events from your instructor. Create a scatterplot

of the data with x representing “year event occurred” and y representing

“estimated year event occurred.” (You might want to record these actual

dates immediately to the left of your estimates in the previous table.)

Why is it appropriate to use the variable “year event occurred” as the explanatory

variable and “estimated year event occurred” as the response variable?

How close were your predictions of events that occurred in the 1980s to the

actual dates?

 What would the scatterplot look like if you had guessed the correct year for

each event?

Sketch the line y = x on your graph. Does it appear that you overestimated more than you underestimated or that you underestimated more than you overestimated or neither? How did you determine this from your graph?

Use Excel to redraw the scatterplot you created previously. To do so, you need

to enter the data in two columns. One column should contain the values of

the explanatory variable and the second column the values of the response

variable.