Explore BrainMass
Share

Explore BrainMass

    Basic statistics using Excel and Eviews

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    See attached files for assignments.

    TASK1
    You are required to prepare a dataset consisting of the Income (X) in £ per week and Years of Education (Y) of 40 randomly chosen adults and then perform the following exercises. (You may enter numbers representing these characteristics of fictitious individuals, provided these are realistic).

    Part A
    All computer work in this section is to be performed using Microsoft Excel software. Define any term you need to use in your answer, draw appropriate diagrams and explain all relevant theory.

    i. Obtain the descriptive statistics and the histogram of the data on Income and discuss whether or not standard deviation is a better measure than Semi Inter Quartile Range for this data.
    ii. Now sort the data in ascending order and then delete the 5 largest and 5 smallest values. You now have 30 numbers representing income of individuals. Repeat the exercise in part (i) above for this reduced data.

    Part B
    All computer work in this section is to be performed using EViews software. Define any term you need to use in your answer, draw appropriate diagrams and explain all relevant theory.

    iii. Obtain the descriptive statistics and the histogram of the data on Years of Education and discuss whether or not standard deviation is a better measure than Semi Inter Quartile Range for this data.
    iv. Now sort the data in ascending order and then delete the 5 largest and 5 smallest values. You now have 30 numbers representing Years of Education of individuals. Repeat the exercise in part (i) above for this reduced data.

    Use Excel to randomly generate 100 observations for the random variable
    (See attached file).

    (ii) Do your answers above suggest that the distribution of the generated numbers is approximately normal? Fully explain your answer.

    © BrainMass Inc. brainmass.com October 10, 2019, 12:13 am ad1c9bdddf
    https://brainmass.com/statistics/frequency-distribution/basic-statistics-using-excel-eviews-283094

    Attachments

    Solution Preview

    Please see the attachments (Word,Excel and E-views file).

    TASK1
    You are required to prepare a dataset consisting of the Income (X) in £ per week and Years of Education (Y) of 40 randomly chosen adults and then perform the following exercises. (You may enter numbers representing these characteristics of fictitious individuals, provided these are realistic).

    Part A
    All computer work in this section is to be performed using Microsoft Excel software. Define any term you need to use in your answer, draw appropriate diagrams and explain all relevant theory.

    i. Obtain the descriptive statistics and the histogram of the data on Income and discuss whether or not standard deviation is a better measure than Semi Inter Quartile Range for this data.

    Descriptive statistics

    Weekly income (Y)
    count 40
    mean 1,261.0250
    sample variance 467,539.6147
    sample standard deviation 683.7687
    minimum 382
    maximum 3170
    range 2788

    1st quartile 807.0000
    median 1,041.0000
    3rd ...

    Solution Summary

    The solution provides step-by-step method for the calculation of basic statistics using Excel and Eviews. Formula for the calculation and Interpretations of the results are also included.

    $2.19