Reference no: EM13829130
Use the data in that data set to create the graphs and tables in questions 1-4 and to answer both parts of question 5. If you cannot figure out how to make the graphs and tables in Excel, you are welcome to draw them by hand and then submit them as a scanned document or photo.
1. Open a blank Excel file and create a grouped frequency distribution of the maximum daily temperatures for the 50 states for a 30 day period.
2. Add midpoint, relative frequency, and cumulative frequency columns to your frequency distribution.
3. Create a frequency histogram using Excel. You will probablyneed to load the Data Analysis add-in within Excel. If you do not know how to create a histogram in Excel, view the video located at: https://www.youtube.com/watch?v=_gQUcRwDiik. Asimple bar graph will also work.
If you cannot get the histogram or bar graph features to work, you may draw a histogram by hand and then scan or take a photo (your phone can probably do this) of your drawing and email it to your teacher.
4. Create a frequency polygon in Excel (or by hand). For help, view https://www.youtube.com/watch?v=7Q-KdmDJirg
5. A. Do any of the temperatures appear to be unrealistic or in error? If yes, which ones and why.
B. Explain how this affects your confidence in the validity of this data set.
Attachment:- Data_Set.xls
|
The importance of appropriately evaluating a loan applicant
: The importance of appropriately evaluating a loan applicant. The need to establish a monitoring system and follow any warning signals carefully.
|
|
Operating assets is considering the purchase of a machine
: (Ignore income taxes in this problem.) A company with $675,000 in operating assets is considering the purchase of a machine that costs $77,000 and which is expected to reduce operating costs by $23,000 each year. These reductions in cost occur evenly..
|
|
Hr representative handling labor relation issues
: Conduct an interview with a Labor Relations or human resources representative who handle labor relation issues regarding unions. This interview comes from the employers' perspective not the union side of the business.
|
|
Scrap value of the projects assets at the end of project
: The management of Helberg Corporation is considering a project that would require an investment of $223,000 and would last for 6 years. The annual net operating income from the project would be $107,000, which includes depreciation of $16,000. The sc..
|
|
Create a grouped frequency distribution
: Create a grouped frequency distribution of the maximum daily temperatures for the 50 states for a 30 day period.
|
|
Describes the issue-story with ethical implications
: Prepare a Powerpoint presentation which describes the issue/story with ethical implications. Please refer to the HTML document for the issue, "Toyota to march workers off Altona plant as job cuts take effect"
|
|
Ratings in the form of predictions-marketing
: Explain Apple Inc. new iPad Air 2 new technology, possibilities, ratings in the form of predictions, marketing, investments and what could occur if these predictions are wrong?
|
|
Risk investments-net present value
: What is the net present value of a commercial real estate investment with the following cash flows, if your required return is 12% of similar risk investments? The cost of retail storefront project is $500,000, but expect to be able to sell it after ..
|
|
Differentiate between the terms recruitment and selection
: The terms recruitment and selection are often used interchangeably and the process is not always sufficiently planned. Explain the difference between the terms recruitment and selection and explain the characteristics of a good recruitment and sel..
|