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

  Point estimation of population standard deviation

a. what is the point estimate of the population mean? b. what is the point estimate of the population standard deviation?

  Winning symbol caps are placed randomly on 5 of the

questiona soft drink manufacturer is using a winning cap as a sales promotion. the purchaser can get a prize if they

  Finding plausible value for correlation

Find out a plausible value r for correlation between vehicle weight and miles per gallon (mpg) shown in the scattergram below?

  Probability score on mathematics part of sat will be more

Both SAT and ACT scores are normally distributed. What is the probability that a randomly selected high school senior's score on the mathematics part of the SAT will be more than 630?

  A national water expert is interested

A national water expert is interested in determining the average amount of lead (in ppm, parts per million) that is found in the Houston, Texas drinking water. To conduct her research, she considers only those residential households within the city l..

  A super market analysed its most recent sales and

a super market analysed its most recent sales and determined the relationship between the way a customer paid for the

  If we assume a normal distribution with o92 what is the

the national average sat score for verbal and math is 1028. if we assume a normal distribution with o92 what is the

  Find the possibility that the household selected

the probability that a household is both prosperous and educated is P (A and B) = 0.082. What is the probability P (A or B) that the household selected is either prosperous or educated.

  Determining joint-probability

Their initial expenditure would be drilling, which would cost $80,000. If they strike gas, they would have to spend an additional $50,000 to cap the well and provide for the necessary hardware and control equipment.

  Find point estimate of the proportion of the population

What is the point estimate of the proportion of the population of employees who strongly dislike their current work experience?

  Perform statistical calculations

Divide your data in half, your first 8 observations and your last 7 observations. Then use ANOVA to test to see if there is a significant difference between the two halves of your data. This list of Webpages that Perform Statistical Calculations h..

  Does the combined data set look normal

Combine the following observations with the above data: 34, 46, 92, 51, 65, 76, 53, 99, 40, 46. Does the combined data set look normal?

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