Share
Explore BrainMass

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.

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