2024 – PLEASE DO NOT FORGET THE DUE DATE I will put the file with same information and we use excel in

PLEASE, DO NOT FORGET THE DUE DATE

I will put the file with same information, and we use excel in this class that means my instructor wants me to use excel. I hope you will use excel

 

BA 301.01

 

Chapter 3 Homework

 

 

 

 

　

 

Identify

 

 

Q1) Examine the data set on the worksheet Q1. This should be familiar; you saw this data set in last week’s homework. Recall that this is a survey of 500 households. The definitions of the variables can be found by reading the comments (the little red triangles).

 

 

 

• Suppose we wanted to examine the distribution of the variable Utilities. It would be appropriate to create a histogram, but we would like to identify measures like the mean, median, and quartiles. What other type of graph could you create?

 

• In order to examine the relationship between the variables First_Income and Second_Income, what type of graph should be created? What summary measures, if any, should be calculated?

 

• In order to examine the relationship between the variables Location and Monthly_Payment, what type of graph should be created? What summary measures, if any, should be calculated?

 

 

 

 

 

 

　

 

Execute

Q2) Examine the data set in the worksheet Q2. This data set lists the 15 players on the 2015-2016 roster of the Los Angeles Lakers. The variables include the name, position, and salary for each player.

 

 

 

Create a side-by-side boxplot for Salary, broken out by Position. In other words, there should be 5 boxplots, one showing the distribution of salaries for those who play center, one showing the distribution of salaries for those who play point guard, and so on. Specifically, this should all be in a single graph.

 

 

 

　

 

Q3) Examine again the data in sheet Q1 (there is no sheet Q3.) We would like to know if the size on one’s family has an effect on their income. Keeping in mind which is the explanatory variable and which is the response variable, create a scatterplot of the variables First_Income and Family Size. Be sure to include the correlation coefficient.

 

 

 

　

 

Q4) Who has been most likely to access the internet over the past decade? Consider the survey data collected from 1,000 randomly selected internet users, given in Q4. Create pivot tables to answer each of the following questions, and be sure to highlight your answer:

 

 

 

a) i. What proportion (percentage) of these internet users is currently employed?

 

ii. What is the average salary of the employed internet users in this sample?

 

b) What proportion (percentage) of these internet users is single with no formal education beyond the high school?

 

c) What proportion (percentage) of these internet users are men under the age of 30?

 

 

 

 

 

　

 

　

 

　

 

　

 

　

 

Interpret

 

 

Q5) Interpret the following. What do you learn? What conclusions can you draw?

 

 

 

In May of 2008, a study was published examining CEO compensation (salary and bonus.) In last week’s homework, you viewed a boxplot of the distribution of compensation, as well as summary measures. Here is the same data, now broken out by company type (there were 10 different company types surveyed: from Basic Materials to Utilities). Side-by-side boxplots are on the next page. Again, what can you conclude?

 

	Comp 08 (Basic Materials)		Comp 08 (Consumer Goods)		Comp 08 (Consumer Services)		Comp 08 (Financials)		Comp 08 (Health Care)
One Variable Summary	Data Set #1		Data Set #1		Data Set #1		Data Set #1		Data Set #1
Mean	$2,483,329		$2,787,126		$2,987,036		$2,342,734		$3,292,771
Std. Dev.	$886,448		$1,815,164		$3,312,399		$2,784,996		$1,732,319
Median	$2,583,000		$2,168,200		$1,500,000		$1,121,400		$3,029,400
Minimum	$792,400		$950,000		$0		$0		$365,300
Maximum	$4,612,800		$11,017,300		$15,945,500		$17,649,500		$6,825,000
Range	$3,820,400		$10,067,300		$15,945,500		$17,649,500		$6,459,700
Count	21		46		75		50		28
1st Quartile	$1,733,500		$1,291,700		$1,022,600		$900,000		$1,868,100
3rd Quartile	$3,002,000		$3,737,800		$3,228,300		$3,600,000		$4,281,500
Interquartile Range	$1,268,500		$2,446,100		$2,205,700		$2,700,000		$2,413,400
1.00%	$792,400		$950,000		$0		$0		$365,300
2.50%	$792,400		$1,096,200		$81,800		$0		$365,300
5.00%	$1,165,000		$1,100,000		$430,000		$100,000		$965,000
95.00%	$3,526,300		$5,522,200		$10,385,000		$5,750,000		$5,995,500
97.50%	$4,612,800		$5,600,000		$14,513,500		$6,000,000		$6,825,000
99.00%	$4,612,800		$11,017,300		$15,945,500		$17,649,500		$6,825,000
	Comp 08 (Industrials)	Comp 08 (Oil & Gas)		Comp 08 (Technology)		Comp 08 (Telecommunications)		Comp 08 (Utilities)
One Variable Summary	Data Set #1	Data Set #1		Data Set #1		Data Set #1		Data Set #1
Mean	$2,648,446	$3,010,437		$2,283,269		$3,319,620		$2,261,056
Std. Dev.	$1,415,705	$1,618,410		$2,515,800		$1,725,552		$991,095
Median	$2,149,200	$2,688,700		$1,579,400		$3,450,000		$2,044,400
Minimum	$768,400	$307,200		$0		$1,420,800		$0
Maximum	$6,024,000	$6,191,700		$11,693,700		$5,840,600		$4,468,300
Range	$5,255,600	$5,884,500		$11,693,700		$4,419,800		$4,468,300
Count	69	27		26		5		34
1st Quartile	$1,452,500	$1,716,700		$856,700		$2,035,300		$1,678,000
3rd Quartile	$3,760,300	$4,420,000		$2,469,600		$3,851,400		$2,913,700
Interquartile Range	$2,307,800	$2,703,300		$1,612,900		$1,816,100		$1,235,700
1.00%	$768,400	$307,200		$0		$1,420,800		$0
2.50%	$917,500	$307,200		$0		$1,420,800		$0
5.00%	$945,900	$1,298,600		$0		$1,420,800		$791,700
95.00%	$5,326,000	$5,870,000		$7,300,000		$5,840,600		$3,674,000
97.50%	$5,925,800	$6,191,700		$11,693,700		$5,840,600		$4,468,300
99.00%	$6,024,000	$6,191,700		$11,693,700		$5,840,600		$4,468,300
Q5) Cont’d

 

 

 

 

 

 

　

 

　

 

Q6) Interpret the graph shown below. What can you conclude about the relationship between these two variables? This is from the data set shown in sheet Q2.

 

 

 

Correlation: 0.605