2.1 Assignment: Reading and Remediation

Watch the following Excel remediation videos:

1. Histograms in Excel
2. Pie Chart using a summary table in Excel
3. Time Series
4. Pareto Chart
5. An optional supplementary textbook is the OpenIntro Statistics, and you can read the concepts there.
6. Use the lab file WS2Practice to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).
7. Use the file WS2Homework to demonstrate the Excel skills.
8. There are 60 points awarded for this exercise, 10 points for each problem.
9. When you have completed your assignment, save a copy for yourself and submit a copy to your instructor by the end of the workshop.

Prb5

.3

4

4

0

	Crickets			Temperature						Place Scatterplot here:						DIRECTIONS:
	882		69.7	Using the data, create a scatterplot. Assign min X axis value = 750 and y axis min of 50.	(8 Points)
	1188	9	3
1	10		84.3						Question:
	86		76.3	Does the chart look like a positive relationship, negative relationship, or no relationship?
1	20		88.6
					(2 points)
10 Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper		32		82.6
	960		71.6
					Source: Essentials of Statistics by Mario Triola
	900		79.6
					Access this helpful video:						Video
	chirps in 1 minute			degrees F

Prb6

Place Scatterplot here: DIRECTIONS:

Question:

0

.9

(2 points)

Source: Essentials of Statistics by Mario Triola

Access this helpful video: Video

Lemon Imports	Crash Fatality Rate
2	30	15.9		Using the data, create a scatterplot. Assign min X axis value = 120. Then create the trend line with the regression equation showing on the chart.					(8 Points 4 for trend line and 4 for equation)
265	15.7
358	15.4
480	15.3	Predict the Crash Rate for 500 tons of lemon imports?
	53		14
weight in tons	per 100,000 people

Prb7

SAT Place Scatterplot here: DIRECTIONS:

00

Using the data, create a scatterplot. Assign min X axis value = 120.
Then create the trend line with the regression equation showing on the chart. (8 Points 4 for trend line and 4 for equation)

Question:

(2 points)

0

Source: Essentials of Statistics by Mario Triola

Access this helpful video: Video

P	SAT
183		22
207	2040
167	1890
206	2380	Predict the SAT for a PSAT of 229
197	2290
1	42	2070
193	2	37
176	1980

Prb8

Place Scatterplot here: DIRECTIONS:

32

(8 Points 4 for trend line and 4 for equation)

103

53 86 Question:

32

(2 points)

42

30 20

27

Source: Essentials of Statistics by Mario Triola

Access this helpful video: Video

Enrollment	Burglaries
	103	Using the data, create a scatterplot. Assign min X axis value = 20. Then create the trend line with the regression equation showing on the chart.
	31
	28		57	Predict the burglaries for 51.8 enrollment?
	27
36	131
157
34
46	161

Prb9

Temperature Place Scatterplot here: DIRECTIONS:

3 57

(8 Points 4 for trend line and 4 for equation)

10 37
14

Question:

22

)?

28

31

(2 points)

thousands of feet degrees F

Source: Essentials of Statistics by Mario Triola

Access this helpful video: Video

Altitude
Using the data, create a scatterplot. Assign min X axis value = 0. Then create the trend line with the regression equation showing on the chart.
24
-5	Predict the temperature for 6.327 (in	thousands of feet
-30
-41
33	-54

Prb10

Crickets Temperature Place Scatterplot here: DIRECTIONS:

882 69.7

(8 Points 4 for trend line and 4 for equation)

1188

84.3 Question:

76.3

88.6

82.6 (2 points)

960 71.6

900 79.6

chirps in 1 minute degrees F

Source: Essentials of Statistics by Mario Triola

Access this helpful video: Video

Using the data, create a scatterplot. Assign min X axis value = 750 and y axis min of 50. Then create the trend line with the regression equation showing on the chart.
93.3	1104
864	Predict the temperature for 1000 chirps per minute?
1200
1032