# Basic statistics using Excel and Eviews

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 December 15, 2020, 5:12 pm ad1c9bdddfhttps://brainmass.com/statistics/frequency-distribution/basic-statistics-using-excel-eviews-283094

#### 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.