Question: Please solve the excel sheet question on this drive all data is here on this link! https://drive.google.com/file/d/10uCS7Jg40bK_k_o_sc72c3WdO2WGamWL/view?usp=sharing I want to get pass please help. Problem

Please solve the excel sheet question on this drive

all data is here on this link!

https://drive.google.com/file/d/10uCS7Jg40bK_k_o_sc72c3WdO2WGamWL/view?usp=sharing

I want to get pass please help.

Please solve the excel sheet question on this driveall data is here

Problem 1 a) Draw the needle graph for the variable Income. b) Calculate the univariate summary measures of all quantitative variables with the Data Analysis Toolpak. Present your results in one parsimonious table, ready to be published. Where is the relative spread largest? Compare the number of children between income categories 2, 4 and 6 by drawing three boxplots on the same graph. Draw the empirical distribution function for TimeLag, without grouping the data. Draw the scatter plot with AHvalue on the horizontal axis and Imed on the vertical axis. Repeat this for the log-transformed variables on the axes (use function LN). Choose between these two situations for constructing the best least-squares line. Problem 2 What is the mode of Y? bi What proportion of the people in the sample with a gross monthly income above 4000 euro has a gross monthly income above 9000 euro? C) Bill successfully followed 6 years of academic education. What is his gross monthly income if 20% of the people with 6 succesful years of education earn more than Bill? d) Calculate the standard deviation of Y/X

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!