You are a nurse supervisor and have just received 75 employee satisfaction surveys. You have taken a random sample of 15 of these surveys. The data set includes variables regarding type of nurse, gender, age, median weekly earnings and employee satisfaction.

Use the data from Table 1 below to complete the questions.

Table 1: Median weekly earnings of nurses at General Hospital.

A	B	C	D	E	F
Nurse ID	Title	Gender	Age	Weekly Earnings	Employee Satisfaction
118963	RN	F	22	$ 1,062.00	3.7
123461	NP	M	26	$ 2,239.00	4.1
128976	BSN	F	32	$ 1,248.00	3.1
129963	LPN	F	44	$ 756.00	3.9
221968	RN	M	59	$ 1,214.00	5.0
312568	NP	M	23	$ 2,041.00	4.4
415569	NP	F	31	$ 2,035.00	3.5
541299	LPN	M	33	$ 843.00	2.8
765552	BSN	F	48	$ 1,278.00	4.0
775132	NP	F	41	$ 1,961.00	4.3
784590	NP	M	62	$ 2,128.00	4.8
864321	BSN	M	38	$ 1,424.00	4.1
865139	LPN	F	44	$ 751.00	3.2
886224	RN	F	53	$ 1,082.00	4.5
896123	BSN	F	66	$ 1,260.00	3.5

1. From the data from Table 1, we can look at the Gender variable.
2. Is the Title variable qualitative or quantitative?

1. Use the data from Table 1 to complete the frequency table of Title (Column B) for the 15 samples. You can use the =countif(B3:B17, "RN") function in Excel, for example.

1. Using the Title frequency table (from part B), create a pie chart for job titles of the nurses. Make sure to include a title and each slice should be clearly labeled and include a percent. Paste your pie chart below.

1. Using the Title frequency table (from part B), create a bar graph for job titles of the nurses. Make sure to include a title your graph and label each axis. (See video links below if needed)

1. Do you think the pie chart or the bar graph displays the differences in the data more clearly for theTitle variable? Why?

1. Input the data from Table 1 into Excel. Calculate the descriptive statistics on Weekly Earnings (Column E) in the table. (See video links below if needed)

1. Paste your Excel descriptive statistics output for the Weekly Earnings variable below.

1. What is the mean Weekly Earnings?

1. What is the standard deviation of Weekly Earnings?

1. Calculate the descriptive statistics for Age (Column D) to answer the following questions.

1. Paste your Excel descriptive statistics output for the Age variable below.

1. What is the mean age of the nurses?

1. What is the minimum age of the nurses?

1. What is the gender of the youngest nurse?

1. Using the Age variable (Column D), create a histogram using the following frequency distribution.

Frequency Distribution

20-29

30-39

40-49

50-59

60-69

1. form a histogram of the Age data of the nurses. Make sure to include a title your graph and label each axis. Paste your graph below. (See video link below if needed)

1. Describe the shape of the histogram in part A. Would this be considered symmetric or skewed?How do you know?

1. Now focus on the Weekly Earnings data (Column E).

1. Calculate the 5-number summary for Weekly Earnings (Column E). Paste the summary below. (See video link below if needed)

1. do a Box plot (Box & Whisker) of Weekly Earnings. Make sure to include a title your graph and label each axis. Paste your graph below.