Solved: Calculate the descriptive statistics, Basic Statistics

+44 141 628 6080
[email protected]

Calculate the descriptive statistics

The Australian Bureau of Statistics recently released figures on petrol usage. Following are the 15 leading cities in 2012.

City                    Value ($ billions)
Bourke                      7.84
Mt Isa    6.48
Weipa                       4.20
Newcastle                 4.17
Wollongong                4.00
Kalgoorlie                   3.30
Darwin                       3.21
Tennant Creek            2.74
Broken Hill                  2.08
Perth    2.05
Alice Springs               2.05
Adelaide                     1.89
Canberra                    1.85
Dubbo                        1.81
Albury                        1.68

(a) Using the Data Analysis Tool in Excel, calculate the descriptive statistics.

(b) Briefly explain what each of the metrics in the summary statistics means.

(c) Comment on the figures in the report. What are they telling you about this data set? Is it symmetrical, flat, skewed, does it have outliers, and so on?

View Complete Question

Solution Preview :

Prepared by a verified Expert

Basic Statistics: Calculate the descriptive statistics

Reference No:- TGS0687670

Now Priced at $30 (50% Discount)

Recommended (98%)

Rated (4.3/5)

Have a Question? (oR Write a Review)

Write atleast 100 words!!

Recent Questions Asked Basic Statistics

Q : Find estimated gross profit-percentage-of-completion method

Using the percentage-of-completion method, compute the estimated gross profit that would be recognized during each year (2014, 2015, and 2016) of the construction.

Q : Offer from an outsider vendor to supply

Avery Corporation has two divisions, A and B, which are both organized as profit centers; Division A produces and sells widgets to Division B and to outside customers.

Q : Relationship between federal government and american citizen

Describe how the New Deal transformed the relationship between the federal government and American citizens. Were there drawbacks to the help offered by the government to the American people during the economic crisis?

Q : Prepare journal entries for given year

Schneider Company uses installment sales method. Below is a summary of its sales, cost of goods sold, and gross profit for three years. Compute the gross profit for 2013, 2014, and 2015.

Q : Calculate the descriptive statistics

Using the Data Analysis Tool in Excel, calculate the descriptive statistics. Briefly explain what each of the metrics in the summary statistics means.

Q : Why the company has expanded the number of lines

Modern Building Supply sells various building materials to retail outlets. The company has just approached Linden State Bank requesting a $300,000 loan to strengthen the Cash account and to pay certain pressing short-term obligations.

Q : Linear function g that gives the number of gallons

Find a linear function G(p) that gives the number of gallons sold as a function of the price of the milk. How many gallons would she then expect to sell at $2.99 per gallon?

Q : What amount of credit must they pay back

After renting an apartment for five years, Todd and Diane purchased a new home on July 1, 2008. On their 2008 joint tax return, they claimed a $4,500 (refundable) first time home buyer credit.

Q : What was the amount of cash received from customers

If sales for the current year were $695,000 and accounts receivable decreased by $43,500 during the year, what was the amount of cash received from customers?

1952215

Questions
Asked

3,689

Active Tutors

1420089

Questions
Answered

Start Excelling in your courses, Ask a tutor for help and get answers for your problems !!

ask Question

Solution Preview :

Prepared by a verified Expert

Basic Statistics: Calculate the descriptive statistics

Reference No:- TGS0687670

Have a Question? (oR Write a Review)

Recent Questions Asked Basic Statistics

Q : Find estimated gross profit-percentage-of-completion method

Q : Offer from an outsider vendor to supply

Q : Relationship between federal government and american citizen

Q : Prepare journal entries for given year

Q : Calculate the descriptive statistics

Q : Why the company has expanded the number of lines

Q : Linear function g that gives the number of gallons

Q : What amount of credit must they pay back

Q : What was the amount of cash received from customers

Is lifespan psychologists are unlikely to investigate

Provide reasons why working from a person centred

Review a social, behavioral, or cultural factor

Outline a social issue that is important to you

Discussion about gender stereotyping

Describe some of your personality traits

Identify a true statement about validity

Solution Preview :

Prepared by a verified Expert

Basic Statistics: Calculate the descriptive statistics

Reference No:- TGS0687670

Recent Questions Asked Basic Statistics

Q : Find estimated gross profit-percentage-of-completion method

Q : Offer from an outsider vendor to supply

Q : Relationship between federal government and american citizen

Q : Prepare journal entries for given year

Q : Calculate the descriptive statistics

Q : Why the company has expanded the number of lines

Q : Linear function g that gives the number of gallons

Q : What amount of credit must they pay back

Q : What was the amount of cash received from customers

Asked Questions