Create line charts for the closing prices, statistics homework help

User Generated

Lbhfrs9

Mathematics

Description

Chapter 3 DQ - problem 1 - revised

Chapter 3, problem 1. Create line charts for the closing prices in the Excel file S & P 500.

Chapter 3 DQ: problem 3 - revised

Chapter 3, problem 3. Please also interpret the scatter diagram.

Chapter 3 DQ: problem 15

No unread replies.No replies.

Chapter 3, problem 15. Also create and interpret the histogram chart.

Week 2 Discussion Question - Problem 3.28 - revised

No unread replies.No replies.

Chapter 3, problem 28. This is a challenging problem. Your score will be based primarily upon participation. You will learn from your classmates and you will also help your classmates learn. Help each other to figure it out.


Unformatted Attachment Preview

Chapter 3 Visualizing and Explorir Problems and Exercises 1. Create a line chart for the closing prices for all years, and a stock chart for the high/low/close prices for August 2013 in the Excel file S&P 500. 2. Create a pie chart showing the breakdown of occupa- tions for each year in the Science and Engineering Jobs Excel file, and contrast these with simple col- umn charts. 3. The Excel file Facebook Survey provides data gath- ered from a sample of college students. Create a scat- ter diagram showing the relationship between Hours online/week and Friends. 4. A national homebuilder builds single-family homes and condominium-style townhouses. The Excel file South region c. the total number of units sold in December 14. Convert the Purchase Orders database to an Excel table. Use the techniques described in Example 3.11 to find: a. the total cost of all orders b. the total quantity of airframe fasteners purchased c. the total cost of all orders placed with Manley Valve. 5. The Excel file Economic Poll provides some demo- graphic and opinion data on whether the economy is moving in the right direction. Convert this data into an Excel table, and filter the respondents who are homeowners and perceive that the economy is not moving in the right direction. What is the distribution of their political party affiliations? tribution and individuals in the Excel file Credit Risk Data. Com- pute the relative and cumulative relative frequencies and use a line chart to construct an ogive. 27. Use the Histogram tool to develop a frequency dis- tribution and histogram for the number of months as a customer of the bank in the Excel file Credit Risk Data. Use your judgment for determining the number of bins to use. Compute the relative and cumulative relative frequencies and use a line chart to construct an ogive. 28. Construct frequency distributions and histograms us- ing the Excel Histogram tool for the Gross Sales and Gross Profit data in the Excel file Sales Data. First let Excel automatically determine the number of bins aavid King, Business Intelligence: A Managerial Approach, 2nd ed. Chapter 3 Visualizing and Exploring and bin ranges. Then determine a more appropriate set of bins and rerun the Histogram tool. 29. Find the 10th and 90th percentiles and the 1st and 3rd quartiles for the time difference between the scheduled and actual arrival times in the Atlanta
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, your work is...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags