Basic statistics using Excel and Eviews
Not what you're looking for?
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.
Purchase this Solution
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.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.