Describe the two frequency distributions

Assignment Help Applied Statistics

Reference no: EM133051994

Problem Set

Problem 1. The data on the sheet Q1 of the file WS2.xlsx reports the reasons of consumer vehicle complaints collected in February 2013 by the Edmunds.com. Use a table to present the information. (Hint: use Excel PivotTable option).

Problem 2. When do Americans decide what to make for dinner? An online survey (N. Hellmich, "Americans Go for the Quick Fix for Dinner," USA Today, February 14, 2005, p.1B) indicated the following:

When Americans decide what to make for dinner	%
At the last minute	37
Plan in advance	25
That day	37
Don't know	1

You can find this table on the sheet Q2 of the file WS2.xlsx.
a. Construct a bar chart, and a pie chart.
b. Which graphical method do you think is better to portray the data?

Problem 3. The data on the sheet Q4 of the file WS2.xlsx are the national debts of 133 countries and regions, as percentages of GDP.

a. Construct a frequency distribution using 5 classes.
b. Construct a frequency distribution using 10 classes.
c. Describe the two frequency distributions and comment on their usefulness in summarising the data.
d. Using 10 classes, construct a histogram, and a frequency polygon.

Problem 4. The data on sheet Q5 of the file WS2.xlsx contains monthly electricity demand data from January 2014 to September 2017. Use appropriate graph to illustrate the data.

Attachment:- Problem Set.rar

Reference no: EM133051994

Questions Cloud

What is the total factory overhead charged to Cornetto : Combate Corp. manufactures ice creams: magnum and cornetto. What is the total factory overhead charged to Cornetto

Determine the economic order quantity : Determine the Economic Order Quantity if daily demand is 400 units, the ordering cost is $70 per order and the annual average cost of holding is $ 10 per unit.

Experiment of organizing kitchen utensils : In assignment 5 you will FINALLY be able to do something about all that nasty waste in your chosen process! You will conduct rapid daily experiments to eliminat

Innovative human-centred health care design : 1. Explain how Noora Health leveraged human-centred design principles to implement the Care Companion Program (CCP).

Describe the two frequency distributions : Describe the two frequency distributions and comment on their usefulness in summarising the data and Construct a frequency distribution using 5 classes

Acceptable level of service : Your company is experiencing high growth resulting in high demand for IT which the IT dept is not able to keep pace with. You need to help the CIO figure out a

Calculate individual gains and losses on each receivables : Calculate individual gains and losses on each of the receivables and payables and the net exchange gain or loss that should appear in Shelton's 2008 statement

Evaluating and testing concepts and ideas : Generating creative and critical thinking concepts that provide innovative solutions to identified issues

Violated company policy and standards : Ethical Dilema: You have developed a formal mentor/mentee relationship with a coworker. You have been a sounding board for this coworker in the past allowing hi

User Account

All Pages