Find the mean and standard deviation, Basic Statistics

Assignment Help:

A travel agency surveyed 38 customers holidaying in Australia who took their spouses on either a skiing or a golfing vacation.  The data comprises amounts (in hundreds of dollars).  The skiing holiday is at Mount Buller in Victoria whereas the golfing holiday is on the Gold Coast in Queensland.

You will now make your data unique by taking the last 4 digits of your student identification number and putting the first two digits at the end of the 'Skiing Holiday' data and the last two digits at the end of the 'Golfing Holiday data.  For example:  If the last 4 digits of your student number are  1234  then put 12 under the value '26' in the 'Skiing Holiday' column and 34 under the value '22' in the 'Golfing Holiday' column.  There will now be a total of 40 values for 40 couples. 

Skiing Holidays ($'00s)

Golfing Holidays ($'00s)

38

24

37

38

29

45

43

19

55

31

41

32

31

44

22

36

21

29

18

32

19

41

23

43

26

37

43

27

32

28

33

21

21

44

16

18

26

22

 

 

Question 1:

a) Show a table that displays all the summary statistics for 'Golfing Holidays' and highlight the values for the mean and standard deviation.

b) Use formula to find the mean and standard deviation for 'Skiing Holidays'.  Write down the formulas shown on the toolbar (to verify that you used the correct formulas).

Question 2:

a) Display a histogram for 'Golfing Holidays' using class widths of 5.  Describe the shape of the distribution in terms of skewness and kurtosis.   What are the values for the skew and for the kurtosis?

b) Display an ogive* for 'Golfing Holidays' and estimate the proportion of holiday makers who spend more than $3,000 on their golfing holiday.

Question 3:

We wish to randomly select eight of the twenty couples from the 'Skiing Holiday' data.  Explain what you must do before you can select the eight couples.  Which Excel technique will you use?  Randomly sample the eight couples and sort the sample data using 'Data-Sort'.  Why is it recommended that the data be sorted?

Question 4:

Of the twenty couples who chose a golfing holiday, 8 couples originated from Japan, 4 from Israel, 5 from India, 1 from Ireland and 1 from Canada.  The twentieth couple is represented by you and your spouse (or friend if you are not married) so you will need to put yourself in one of the categories or create a new category (showing your country of origin). Show two different ways of displaying this information to best advantage (one of these displays must not be a frequency distribution).

Question 5:

  a)  It has been determined from past golfing data that the number of hours a couple spend playing golf per day is normally distributed with a mean of 5 and a standard deviation of 2. Use an appropriate Excel function (ƒx) to determine the probability that a couple spend more than 6 hours playing golf per day.  Write down the formula shown in the shortcut tool bar.

 b)  Snowfalls occur randomly and independently over the course of winter on Mount Buller.  The average is one snowfall every three days.  Find the probability of a snowfall the day you and your friend plan to ski.  Use an appropriate Excel function (ƒx) and write down the formula shown in the shortcut tool bar.

Question 6:

Can we infer that skiers and golfers differ in their vacation expenses? Test at the 1% level of significance. Highlight the relevant critical value or p-value and the test statistic.


Related Discussions:- Find the mean and standard deviation

How many trucks get washed between smokes, A. Northbound trucks leaving Hel...

A. Northbound trucks leaving Helmand Province with USMC communications equipment must go through a washing process before getting underway, so as to prevent Tajikistan from gett

Historigram, what is historigram in statistics please give the problems and...

what is historigram in statistics please give the problems and there solution in statistics as soon as possible

Calculate the expected profit and probability , An individual has $ 100 ini...

An individual has $ 100 initially. He repeatedly plays a game of chance in which he earns $ 100 with probability 0.8 or loses $ 100 with probability 0.2. The stops playing at the f

Internal rates of return , A consumer product firm finds that its brand of ...

A consumer product firm finds that its brand of laundry detergent is losing market share, so it decides that it needs to "freshen" the product. One strategy is to maintain the curr

Cost accounting , is direct costing variable, relevant or prime costing

is direct costing variable, relevant or prime costing

T accounts, if my income for the rest of the month was 2,500 and i recieved...

if my income for the rest of the month was 2,500 and i recieved 1,200 in cash balance on account where would i put this

Chi-square Test, six subjects were exposed to 4 treatments and the followin...

six subjects were exposed to 4 treatments and the following data were recorded

Determine the local luminance, 1. Consider a room 3 m x 3m x 3m with one fa...

1. Consider a room 3 m x 3m x 3m with one façade made of glazing with diffuse transmittance 0.6 and reflectance 0.2. The interior surfaces have a reflectance of 0.5. Consider incid

Asked in genpact interview, Expenses a/c. Dr. To vendor a/c. Cr. What is a...

Expenses a/c. Dr. To vendor a/c. Cr. What is an impact of this transaction on business

Automatic interaction detector (aid), Automatic interaction detector (AID) ...

Automatic interaction detector (AID) A method or the technique which uses a set of categorical explanatory variables to divide data into the groups which are relatively homoge

Write Your Message!

Captcha
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!

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