What is the best statistic used to compare the volatility

Assignment Help Applied Statistics
Reference no: EM131065972

Statistics for Business and Finance Assignment-

The Data Set for the end of semester Assignment is in a file called Data Set for Assignment.xls which presents Weekly Income (WI), Weekly Expenditure on Food (WEF), Highest Level of Education (HLE), Family Size (FS), and Gender of the Head of Household (GHH) for the a population of 1000 households.

  • Column A consists of Households are named by number from 1 to 1000.
  • Columns B to F record these households' WI, WEF, HLE, FS and GHH, respectively.
  • Column I presents 100 samples of households as your sample, consisting:

-1st household is based on the first 3 digit of your student ID

-2nd household is based on the last 3 digit of your student ID

-3rd - 5th is based on the day, month and the last 2 digits year of your birthday, respectively.

-6th - 100th is randomly chosen.

  • Example: if your student ID is: 181XX728 and you were born in 31st of March 1985

-1st household is no. 181

-2nd household is no. 728

-3rd household is no. 31, 4th is no. 03, and 5th is no. 85

-6th to 100th is randomly chosen

Assignment Tasks-

Task 1-

A. Organize your sample data in a spreadsheet as per "Instructions" above. (Students who failed to follow the instructions will not be marked and "0" mark will be awarded to them)

B. What sampling method is used to select your sample data?

C. Do you think that is the best method of sampling? Why not? Why yes?

D. What is the best statistic used to compare the volatility in WEF, WI, and FS values? Why?

Task 2-

Based on your sample data:

A. Develop the tabular form and graphical bar chart of WI based on the following classification:

1st Class = Very Poor

2nd Class = Poor

3rd Class = Moderate

4th Class = Rich

5th Class = Very Rich.

B. What is the most frequent group in your WI sample data? What does that indicate in terms of your data distribution?

C. Do you think your WI of sample data is normally distributed? Provide the "statistical reason" for your answer?

Task 3-

A. What is the top 10% and bottom 10 % of your WEF household values?

B. What is the probability that your WI values will be less than or equal to $200?

C. What is the probability that FS will be equal to 2?

D. Is there any outlier(s) in your sample data of WEF? Show the graph or prove for that! If yes, what is the best statistic to measure the dispersity of your WEF?

Task 4-

A. What is the probability that the head of household is woman and her HLE is Primary?

B. What is the probability that the head of household is man and has the College degree?

C. What is the proportion of having the Secondary as the highest degree from among males?

D. What is the proportion of having the Intermediate as the highest degree from among males?

E. Do you think that the events "gender of household head is male" and "having the College Degree" are independent?

For task 5 an onwards, assume that your sample data is normally distributed.

Task 5-

A. Provide the most accurate of interval estimate of WI and interpret your result.

B. Provide the least accurate of interval estimate of WEF and interpret your result.

C. Provide the most and least accurate of interval estimates of FS and interpret your result.

D. Explain the main differences between the most and least accurate of interval estimate! Why they called as most and least accurate of interval estimate?

Task 6-

A. After surveying many countries, Michael Scott, one of La Trobe University researchers believes that in order to be considered as the wealthy city, the average weekly income of the household would be at least $1200. Based on the statement above, can you consider your sample data is from a wealthy city? (α = 0.10)

 B. Michael Scott also believe one city can be considered as the fertile city if the average of family size of household is greater than 8 (μFS > 8). Based on the statement above, can you consider your sample as the fertile city? (α = 0.05)

 C. Michael Scott also believes one city can be considered as the obese city if the average spending of Weekly food expenditure of household is greater than or equal to 50. Based on the statement above, can you consider your sample as the obese city? (α = 0.01)

D. Based on the calculation above, which prediction is the most accurate and why?

Task 7-

 A. What is the relationship between the amount of WEF and FS in your sample?

B. What is the relationship between the amount of WI and gender of the family head in your sample?

C. How the HLE and WI do affected the WEF in your selected sample?

NB: Use the linear regression line to estimate, R, R2 and graph in order to explain the relationship.

Task 8-

As one of the largest city in USA, New York is also known as the food city. In this city people spend so much money in food, and Bill de Blasio, Mayor of New York believes, that the average amount of weekly income (WI) spent by households is not equal with your sample data. In order to prove that he collects a random sample of 50 households data of his city. (The data is attached on excel file New York tab).

Based on the Bill de Blasio's statement, perform the analysis on hypothesis testing with level of significance of 5%. Do you think Bill de Blasio's statement is correct? You may consider the following assumptions while performing this test:

A. Populations for both of your sample and New York data are normally distributed and samples are independent.

B. Population variances of Weekly Food on Expenditure (WEF) are unknown and unequal.

Attachment:- Data Set for Assignment.rar

Reference no: EM131065972

Questions Cloud

Explain the relationship between mission : Explain the relationship between mission, vision and value statements and their importance to strategic planning. Where does this fit when considering the construction of a business plan.
Sources of capital for a for profit company : What are the sources of capital for a for profit company? What are the sources of capital for a not for profit organization? What are the pros and cons of the various sources of capital?
Develop a solution that would improve system performance : Note: This example includes advanced topics, and you are not expected to understand the article fully. It is offered here simply as an example of how these techniques may be employed to solve IT problems.
Calculate the break even point : Bunglers Furniture makes benches and sells them for £80. Materials and other direct costs are currently £14,000 a year. It has overheads of £8,180 and a wage bill for staff of £32,000. The gross profit per sale is calculated to be £38. Calculate th..
What is the best statistic used to compare the volatility : Statistics for Business and Finance (BUS5SBF) Assignment. What sampling method is used to select your sample data? Do you think that is the best method of sampling? Why not? Why yes? What is the best statistic used to compare the volatility in WEF, W..
Purchased a new donut maker : Jimba's, Inc., has purchased a new donut maker. It cost $20,000 and has an estimated life of 10 years. The following annual donut sales and expenses are projected:
Prepare a business plan milestone based on a hair salon : Prepare a Business Plan Milestone BASED ON A HAIR SALON. A timeline outlining the interrelationships and timing of major events planned for your venture. Make sure that your deadlines are realistic and attainable.
Estimating the cost ($k) of optical sensors : Using the preliminary calculations from a data set of 9 sensors, determine the equation of the line. (Round your intermediate calculations to 3 decimal places)
Share of warren common stock : On May 1, 2010, Warren Co. issued $500,000 of 7% bonds at 103, which are due on April 30, 2020. 20 detachable stock warrants entitling the holder to purchase for $40 one share of Warren's common stock, $15 par value,

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

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