10 Sep 1. Text Book Problems to complete: Chapter Two Work: p. 56: 2.25, p. 63: 2.37, p. 64: 2.41, p. 68: 2.57

1. Text Book Problems to complete: Chapter Two Work: p. 56: 2.25, p. 63: 2.37, p. 64: 2.41, p. 68: 2.57

To find the data for each problems, follow this link  https://media.pearsoncmg.com/ph/esm/esm_levine_lsxl9e_21/cw/lsxl9e_student_download.html (Links to an external site.)  (Links to an external site) Click on the Excel Data Workbooks.  Be sure to know the name of the data set.  For example, 2.37 requires data set “Mobile Speed.

2. Non-text Book Problems to complete:

The federal government is required to have a diverse workforce. The diversity factor of educational levels is an important metric. In your agency there are 29 PhDs, 52 master’s degree (MS), 225 bachelor’s degrees (BS), 42 associate’s degree (AA) and 164 with just high school degrees (HS). With this data   a. Make a frequency table.   b. Make a relative frequency table.   c. Make a bar chart using counts on the y-axis   d. Make a relative frequency bar chart using percentages on the y-axis    e. Make a pie chart    f. Write two sentences summarizing the data.

Please complete the work in a word document or Excel or a combination of both.  Please submit both the text book and non-text book problems in the same document. Please upload and submit the work online through this assignment link. 

Due date: Wednesday September 7, 2022 by 11:59 PM EST

3. Discussion Board Assignment: Search online for an example of data presented in a visual format (table, chart, plot, graph, etc.), that creates a false impression that would lead to misleading or unproductive analysis. Post the graphic in the Discussion Board labeled “Misleading Graphics.” Be sure to provide any context that is needed to demonstrate what is incorrect concerning the graphic. Be sure to include the online link to the location of the graphic.

Then choose one classmate’s post. Using the pitfalls described in Chapter 2.9, in a sentence, describe one reason why this would be considered misleading. IF someone has already listed the reason, then you MUST choose another graphic.  One post has only one reply!

Initial Post with the graphic example due  Wednesday September 7, 2022 by 11:59PM EST

2.25 How do college students spend their day? The 2016 American Time Use Survey for college students found the following results:

2.37 The file [Mobile Speed] contains the overall download and upload speeds in Mbps for nine carriers in the United States.

Source: Data extracted from Tom’s Guide, “Fastest Wireless Network 2019: It’s Not Even close,”  bit.ly/2PcGiQE.

For download and upload speeds speeds separately:

a. Construct an ordered array.

b. Construct a stem-and-leaf display.

c. Does the ordered array or the stem-and-leaf display provide more information? Discuss.

d. Around what value, if any, are the download and upload speeds concentrated? Explain.

2.41 How much time do Americans living in cities spend commuting to work each week? The file [Commuting Time] contains these times for 30 cities.

Source: Data extracted from “American Factfinder,”  factfinder.census.gov.

For the time Americans living in cities spend commuting to work each week:

a. Construct a percentage histogram.

b. Construct a cumulative percentage polygon.

c. What conclusions can you reach concerning the time Americans living in cities spend commuting to work each week?

2.57 The Super Bowl is a big viewing event watched by close to 200 million Americans that is also a big event for advertisers. The file [Super Bowl Ad Costs] contains the average cost for 30-second ads that ran between the opening kickoff and the final whistle for the 2004 to 2019 Super Bowls.

Source: Data extracted from www.admeter.usatoday.com/results/2019. 

a. Construct a time-series plot. 

b. What pattern, if any, is present in the average cost for 30-second ads that ran between the opening kickoff and the final whistle?