User Account

All Pages

Using the data analysis tool in excel calculate the

Assignment Help Basic Statistics
Reference no: EM13582828

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?

Reference no: EM13582828

Questions Cloud

If sales for the current year were 695000 and accounts : the cash flows from operating activities are reported by the direct method on the statement of cash flows. determine
After renting an apartment for five years todd and diane : after renting an apartment for five years todd and diane purchased a new home on july 1 2008. on their 2008 joint tax
Find a linear function gp that gives the number of gallons : the owner of a grocery store finds that she sell 980 gallons of milk each week at 2.69 per gallon and 1220 gallons of
Modern building supply sells various building materials to : modern building supply sells various building materials to retail outlets. the company has just approached linden state
Using the data analysis tool in excel calculate the : the australian bureau of statistics recently released figures on petrol usage. following are the 15 leading cities in
Schneider company uses installment sales method below is a : schneider company uses installment sales method. below is a summary of its sales cost of goods sold and gross profit
Describe how the new deal transformed the relationship : describe how the new deal transformed the relationship between the federal government and american citizens. were there
Avery corporation has two divisions a and b which are both : avery corporation has two divisions a and b which are both organized as profit centers division a produces and sells
Using the percentage-of-completion method compute the : chase construction company ccc entered into a contract to build a parking complex. the project will commence on

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd