Perform several tasks, such as data entry, using the functions command and if statements.

This homework is designed to give you some experience with Excel. With this exercise, you’ll perform several tasks, such as data entry, using the functions command and if statements.

Read through all the problems and set them up and then solve all of them. Once you are comfortable with your responses, go to Moodle to submit them. You have only one opportunity to submit your responses. Therefore, you should only open the link to submit your answers when you are fully ready to submit all your responses. Be very careful to submit your responses as instructed or Moodle with grade them as incorrect.

I have purposefully not gone over all the functions you will use in HW1 in Excel Lab 1. After completing Excel Lab 1, you should now know how to search for a function and to use the argument box to understand the data required to solve for a given function. Also, some of the functions, such as STDEV (Standard Deviation) you should be familiar with from your previous statistics course. The idea here is to provide you with more real-life examples you are likely to encounter when analyzing data as a healthcare administrator where you will have to formulate your own hypotheses and analyze the data that makes sense to your specific needs.

A well-baby clinic record the weight for the following infants receiving services during one work-day. The weight of the infants is given below in pounds. Enter the data into a spreadsheet and answer the following questions. You should enter these data into a single column, not in three rows as shown.

 

10.7 18.2 17.8 16.0 17.8 15.9 21.5
17.1 20.6 18.8 15.4 20.8 19.8 18.3
17.2 15.8 10.8 19.6 17.9 17.8 14.5
12.5 18.5 20.1 13.9 19.5 21.4 19.2

 

  1. Use the COUNT function to determine the number of observations. Report as an integer.
  2. Use the SUM function to obtain the total weight of all infants coming to the clinic on the given day. Round to nearest tenth – 1 decimal place.
  3. Use the AVERAGE function to determine the average weight of infants coming to the clinic. Round to the nearest tenth – 1 decimalplace.
  4. Use the AVERAGEIF function to determine the average weight of infants weighing 15 lbs. or more. Round to the nearest tenth – 1 decimal place.
  5. Use the MEDIAN function to determine the median weight of the infants coming to the clinic. Round to the nearest tenth.
  6. Use the MAX function to determine the weight of the heaviest child coming to the clinic. Round to the nearest tenth.
  7. Use the MIN function to determine the weight of the lightest child coming to the clinic. Round to the nearest tenth.
  8. Use the SMALL function to find the weight of the 5th lightest infant. Report to the nearest tenth
  9. Use the LARGE function to find the weight of the 10TH heaviest infant. Report to the nearest tenth.
  10. Use the STDEV.P function to compute the standard deviation the infants coming to the clinic. Round to the nearest tenth.
  11. Use the VAR.P function to compute the variance of infant weights coming to the clinic. Round to the nearest tenth.
  12. Create an IF statement (using the IF Function) that determines whether the infant is greater or less in weight than the overall average for all infants and assign a 1 to those greater than the average and equal to OR less than the average. How many infants are above the average weight? Report as an integer. Hint: After creating the IF statement, use the SUM function to count the number of infants with above average weight.
  13. Create an IF statement (using the IF Function) that determines whether the infant is less than 15 lbs., greater than or equal to 19.5 lbs. or between the two extremes. Assign “Low” to lightest group, “High” to the heaviest group and “Medium” to the middle group. How many infants are in the Medium group? Report as an integer. Hint: After creating the IF statement, write a second IF statement and assign a 1 to those classified as “Medium” from your first IF statement and assign 0 to all other values. Then use the SUM function to count the number of infants classified with “Medium” weight.

 

Now open the Excel file on Moodle in the HW1 Folder entitled HW1.xls. Within this file are some sample Medicare billing data. By now you should begin to recognize which function should be used given the question. In each question, you aren’t always given the function and should think about the question and use the appropriate function.

  1. What is the average age of the patients in your database? Round to the nearest tenth – 1 decimal place.
  2. What is the median age of the patients in your database? Round to the nearest tenth.
  3. What is the most common age of the patients in your database? Report as an integer
  4. How old is your youngest patient? Report as an integer.
  5. How old is your oldest patient? Report as an integer.
  6. There are more male than female patients in your database.

True/False

  1. What is the Average Length of Stay (LOS) for male patients in your database? Hint: Use the AVERAGEIF function. Round to the nearest tenth

Welcome to one of the bestassignmenthelpcompanies  online .

·         Do you want to order for a customized assignment help task?

·          Click on the order now button 

·         Set up your topic, Fix the number of pages, Fix your Order instructions 

·         Set up your deadline, upload the necessary files required to complete the task, Complete the payment.

 We delivery high quality and non plagiarized tasks within the stipulated time given 

SL