1.You should submit ONE document with all analyses and answers (probably a Word document - even...

Question

1.You should submit ONE document with all analyses and answers (probably a Word document - even though your analyses will be completed in Excel). Use the question numbers to separate and outline your document.

2. For questions 1 and 2, your answers should be a combination tables, graphs, charts, and text. You should also be careful NOT to be redundant in providing the aforementioned information.

3. For questions 3 - 5, where very specific questions are asked, you do need to answer the questions asked AND provide the data that supports your answers. Import from Excel as needed for these questions.

Deals and Aptitude Data Instructions Demographic Information: Gender: 1=Female 2=Male Age: 22 – 70 -- 22-31 32-41 42-51 52-61 62+ Years @ Company: 1 – 15 -- 1-5 6-10 11-15 Level @ Company: 1=Chief 2=Director Variables: Skills: 10 - 20 Approval: 30 - 50 Aptitude: 50 - 75 Progress: 1 - 5 Deals (in $10,000): 62 - 90 Days/Year: 30 - 50 Questions: 1. Summarize the demographic information using frequencies, means and SDs, and /or class intervals with tables, graphs, and text. 2. Summarize the variables using frequencies, means and SDs, and /or class intervals with tables, graphs, and text. 3. Based on deals and aptitude only, which three employees within each level @ company deserve to be promoted? (6 total employees) Present all data to support your conclusions. 4. For skills, progress and days/year, which three chiefs and which three directors report the highest scores. (6 total employees) Present all data to support your conclusions in table form. 5. To what extent is skills related to deals across both levels @ company? To what extent is skills related to deals within each level @ company? Present all data to support your conclusions. Guidelines for Presenting Data 1. Use two decimal rule, i.e. 22.36 not 22.3567. 2. For continuous data, provide means and SDs. For categorical data, provide percentages only. Do not information beyond the data that answers the question(s) asked. 3. When creating tables for demographic information or variables, put higher scores first and/or at the top. 4. Pay attention to scale. Which chart is better and why? Each depicts the same set of data. . 5. Your submission should be one document with a mix of tables, graphs, and text related to each of the five questions. Do not repeat information in tables, graphs, and text. 6. Use the five questions as headings to provide structure to your paper. Series 1Category 1Category 2Category 3Category 44.32.53.54.5 Series 1Category 1Category 2Category 3Category 44.32.53.54.5

deals-and-aptitude-data-dohulr1j.xlsx deals-and-aptitude-data-1-egh4oxpn.docx

Vignesh · Accepted Answer

Deals and Aptitude Data Instructions
1. Summarize the demographic information using frequencies, means and SDs, and /or class intervals with tables, graphs, and text. 
Frequency table and chart for gender
	gender
	Frequency
	female
	23
	male
	22
The above chart shows that female count is high while comparing with male count
Frequency table and chart for Age
	Age interval
	Frequency
	22-31
	10
	32-41
	6
	42-51
	11
	52-1
	8
	>62
	10
The above chart shows that age interval of 42-51 data collected is high
Frequency table and chart for years interval
	Years interval
	Frequency
	1-5
	12
	6-10
	12
	11-15
	11
	>16
	10
The above chart shows that interval of 1-5,6-10 shows the same count at years at company
Frequency table and chart for Levels at company
	Levels
	Frequency
	Chief
	18
	director
	27
The above chart shows that director level at company is high 
Summary statistics for demographic variables
	Gender
	 
	Age
	 
	year@co
	 
	level@co
	 
	
	
	
	
	
	
	
	
	Mean
	1.488889
	Mean
	46.77778
	Mean
	10.08889
	Mean
	1.6
	Standard Error
	0.075359
	Standard Error
	2.23672
	Standard Error
	0.872024
	Standard Error
	0.073855
	Median
	1
	Median
	49
	Median
	10
	Median
	2
	Mode
	1
	Mode
	49
	Mode
	8
	Mode
	2
	Standard Deviation
	0.505525
	Standard Deviation
	15.00438
	Standard Deviation
	5.849717
	Standard Deviation
	0.495434
	Sample Variance
	0.255556
	Sample Variance
	225.1313
	Sample Variance
	34.21919
	Sample Variance
	0.245455
	Kurtosis
	-2.09302
	Kurtosis
	-1.0583
	Kurtosis
	-1.19801
	Kurtosis
	-1.90845
	Skewness
	0.046003
	Skewness
	-0.22437
	Skewness
	-0.01801
	Skewness
	-0.42246
	Range
	1
	Range
	48
	Range
	19
	Range
	1
	Minimum
	1
	Minimum
	22
	Minimum
	1
	Minimum
	1
	Maximum
	2
	Maximum
	70
	Maximum
	20
	Maximum
	2
	Sum
	67
	Sum
	2105
	Sum
	454
	Sum
	72
	Count
	45
	Count
	45
	Count
	45
	Count
	45
2. Summarize the variables using frequencies, means and SDs, and /or class intervals with tables, graphs, and text.
Frequency table and chart for Skills
	skills
	Frequency
	11.00
	5
	12.00
	6
	13.00
	3
	14.00
	1
	15.00
	4
	16.00
	4
	17.00
	4
	18.00
	7
	19.00
	5
	20.00
	6
The above chart shows that the highest skills at company is 7
Frequency table and chart for Approval
	Approval
	Frequency
	30.00
	1
	31.00
	2
	32.00
	2
	33.00
	4
	36.00
	2
	37.00
	1
	38.00
	5
	39.00
	2
	40.00
	3
	41.00
	1
	42.00
	3
	43.00
	3
	44.00
	3
	45.00
	3
	46.00
	4
	47.00
	1
	48.00
	2
	49.00
	1
	50.

1.You should submit ONE document with all analyses and answers (probably a Word document - even though your analyses will be completed in Excel). Use the question numbers to separate and outline your...

Answer To: 1.You should submit ONE document with all analyses and answers (probably a Word document - even...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment