Module 1 Minitab Assignment

Instructions:

Below you will find questions and a sample dataset. Please use the provided dataset to complete the tasks and to answer the questions.

As part of a research project, an advertising firm conducted a small survey of 15 households. One variable of interest was the number of televisions in each household. The result of this survey is given below.

Create a tally of the data showing counts and percentages.

Construct a pie chart for this data. Include the percentages for each category on the chart. Give the chart an appropriate title.

Construct a bar chart for this data. Include the percentages for each category on the chart. Give the chart an appropriate title.

What proportion of the sampled households had exactly 2 televisions?

What proportion of the sampled households has at most 1 television?

Dataset:

2

1

1

1

0

1

0

1

2

2

1

2

1

1

1

(continued on next page)

Super Bowl television broadcasts rate among the highest in all television broadcasts. The Television Bureau of Advertising published a report titled TV Basics. Part of the that report listed the television ratings for 20 Super Bowls, as shown below.

Construct a relative histogram for these ratings. Use the bins 3941, 4143, 4345, 4547, 4749, and 4951. Label the vertical axis using relative frequencies.

Based on the histogram, determine what range of ratings was most common.

Construct a dot plot for these ratings.

Construct a stem-and-leaf plot of these ratings.

Based on the statistical plots in (a)-(c), how would you describe the shape of the distribution?

Dataset:

45.5

42.8

43.1

49

46.3

49.3

44.7

49.6

42.6

45.3

46.2

41.6

42.3

48.6

39.3

49.4

50.3

42.7

43.6

49.3

(continued on next page)

The exchange rate between the United States and Canada can be stated as the number of Canadian dollars that can be purchased with $1. Values for the years 2008-2020 are given in the table below.

Make a time plot of this data and comment on any overall long-term trends.

During what year is the exchange rate at its highest?

Between which two years is the decline in the exchange rate the greatest?

Dataset:

Year Exchange Rate Dataset

2008 1.79

2009 1.39

2010 1.33

2011 1.44

2012 1.39

2013 1.21

2014 1.53

2015 1.29

2016 1.17

2017 1.74

2018 1.55

2019 1.41

2020 1.5

Consider the following bivariate data set.

Create a scatter plot of the data.

Comment of the type, direction, and strength of the relationship between the variables.

Dataset:

x y

76 53

93 68

82 63

104 34

100 63

86 39

96 33

83 40

80 42

85 70

77 48