A manager collected information on a random sample of 7 employees. He then entered the data into Microsoft Excel asshown below.“ в 1 Hourly wage Age Number of days of sick leave 2 49 55 48 60 52 54 5...


A manager collected information on a random sample of 7 employees. He then entered the<br>data into Microsoft Excel asshown below.“<br>в<br>1 Hourly wage<br>Age<br>Number of days of sick leave<br>2<br>49<br>55<br>48<br>60<br>52<br>54<br>5<br>50<br>60<br>6.<br>53<br>54<br>51<br>40<br>8.<br>58<br>44<br>mean =<br>10 sample SD =<br>11<br>mode =<br>(i) Write an Excel command to find the mean hourly wages of the selected employees.“<br>(ii) Write an Excel command to find the sample standard deviation of the number of days<br>of sick leave of the selected employees.<br>(iii) Write an Excel command to find the mode of the age of the selected employees.e<br>(iv) Consider the following boxplot. Calculate the interquartile range. Give the exact<br>answer.<br>400<br>425<br>450<br>475<br>500<br>525<br>550<br>575<br>600<br>625<br>

Extracted text: A manager collected information on a random sample of 7 employees. He then entered the data into Microsoft Excel asshown below.“ в 1 Hourly wage Age Number of days of sick leave 2 49 55 48 60 52 54 5 50 60 6. 53 54 51 40 8. 58 44 mean = 10 sample SD = 11 mode = (i) Write an Excel command to find the mean hourly wages of the selected employees.“ (ii) Write an Excel command to find the sample standard deviation of the number of days of sick leave of the selected employees. (iii) Write an Excel command to find the mode of the age of the selected employees.e (iv) Consider the following boxplot. Calculate the interquartile range. Give the exact answer. 400 425 450 475 500 525 550 575 600 625

Jun 01, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?