Instructions

Today there are 195 sovereign countries in the world that are officially recognized. One can choose to look at many types of data coming from these countries, as there is a plethora of existing information. For this assignment you will be looking at populations of cities within China at three different times (depending on when a census was taken). The data for these cities can be found in the file named (attached) Populations. Use all of the data points for each of the years given, but please note that not every city has a population for each census.

Prepare a report (see below) using numerical methods of descriptive statistics to show how the populations of the cities vary over the years (growth rates). Be sure to include the following three (3) items in your report.

• Compute descriptive statistics for each of the years along with an explanation of what the descriptive statistics tell us about the different years. Are they continually growing, or is there a decrease in the number of people? The descriptive statistics will include the mean, mode, range, standard deviation, and the 5-number summary (minimum, first quartile (Q1), median (Q2), third quartile (Q3), and maximum).
• Determine which cities, if any, should be considered outliers in each of the years? If there are any outliers in any year, please list them and state for which year each one is an outlier. Use the z-score method to determine outliers for this question showing the z-score calculations for each city and year in your spreadsheet.
• Determine the correlation coefficient between the first year and each of the other years. Please provide an explanation of the relationships. Show your calculations for each correlation coefficient within the spreadsheet.

Paper Requirements

Write a report. Items that should be included, at a minimum, are a title page, an introduction, a body which answers the questions posed in the problem, and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. As with all written assignments, you should have in-text citations and a reference page. Please include any tables of calculations, calculated values, and graphs associated with this problem in the body of your assignment response.

Note: You must submit your Excel file with your report. This will aid in grading with partial credit if errors are found in the report.

Instructions

After working for 18 months in your analyst position at G&B Consulting, you are now being considered for a project manager position that would put you in charge of several team members. As part of the interview process, you have been asked to make a presentation to highlight what you think are the most compelling reasons you should get the position.

You are to put together a PowerPoint presentation that explains all of the key components that you feel will factor into why you should get the position.

What to Submit

To complete this assignment, you must first download the word document. Use the questions on the worksheet as your guide for the contents of your presentation.

Your step-by-step breakdown of the problems, including explanations and all work shown, should be present within the PowerPoint you create. If you use Excel for any of your calculations that file must also be included in the drop box. Do not submit the Word document with instructions.

Need the below Discussion question answered 275 words APA format with 3 scholarly sources less than 5 years old No Cover page needed Topic 1: Pediatric Health Maintenance Exam and PPE The foundation of pediatric healthcare visits, both sick and well, starts with a thorough health history; from the data collected, an accurate physical examination and diagnosis can be made. Primary care healthcare visits are an integral part of ensuring the health and well-being of the child. In children that participate in sports, a preparticipation physical examination (PPE) is required and may be the only contact the healthy child has with their healthcare provider. This week’s Discussion will focus on these key topics. Your professor will assign a topic to present and, in return, you will reply to your classmates in the other topics in order to promote a robust discussion. Please complete each post in APA format following the Discussion Board grading rubric. Topic 1: What are the different types of pediatric health histories? When would you use each specific type? Topic 2: What is the review of systems (ROS)? In a SOAP note, where does the ROS belong? What is the relationship between the ROS and the physical exam? Topic 3: Shelby is a 5-year-old female, brought to the clinic by her parents and will be starting kindergarten in the fall. The parents state that she needs her physical and shot record to register her for school. The parents state that she has been healthy and voice no concerns although Shelby is “scared” about the exam and vaccines. How would you address Shelby’s fear of the exam and vaccines? What age-appropriate screenings and lab tests are recommended for Shelby? What immunizations will Shelby require, if any? Topic 4: Peyton is a 2-month-old female brought to the clinic by her 18-year-old mother for her health maintenance exam. What should the physical examination focus on for this child? What immunizations are due, if any? What age-appropriate anticipatory guidance topics should be discussed with mom? Topic 5: George is a 12-year-old male brought to the clinic by his father and wants to start playing football and needs a preparticipation physical examination (PPE). He is an established patient in your practice and his last health maintenance exam was at 11 years of age. In reviewing his health history, you note that he has sickle cell trait but otherwise healthy. During his exam, you auscultate a Grade I murmur, and the remaining exam is normal. Dad asks if you will clear George to start football practice tomorrow. Would you clear George? Why or why not? Are there any specialists George needs to see before clearance? What are some of the preventive measures you would discuss with George and his father related to playing sports, specifically football?

Transcript

Chapter 06: Now What? video

>> Hey, Ryan. What’s going on? Hey, you look upset. Are you all right?

>> I just learned that Happy Time pays John more than me, even though I was hired a year before he was. Do you believe that?

>> Well, why do you think that is?

>> I wish I knew. Maybe he’s related to someone in the company. But we should be paid the same if we do the same job, right? Having a hard time trusting this company to do the right thing if they can’t even be fair with this.

>> Wow, that does seem unfair. You must be pretty upset.

>> Yeah, I am. See you later.

>> Hey, Ryan. How’s it going?

>> John, good.

>> Is that your new car out there?

>> Yeah, yeah, it is.

>> She’s a beauty.

>> Yeah, thanks. I love those new heated leather seats. It’s great. Hey, when are you going to get yourself one of those?

>> I’m just weighing my options now, you know? Just seeing how things go.

>> I’ll see you later, man, all right?

>> Yeah, yeah. I’m so underpaid. A few extra supplies could really boost my paycheck.

>> You know, John’s probably just been lucky, you know? Maybe your luck will turn around.

>> It better. This is so unfair.

>> Well, hang in there, Ryan.

>> Hello?

>> Hey, Billy. Did you hear about John?

>> No, what do you mean?

>> I don’t know how many people know about this, but I heard he’s considering another job.

>> Really?

>> Yeah. I also hear he’s thinking about moving to one of our competitors and starting a Toy Land like our new one that he can run as brand manager.

>> I don’t believe it. That would really hurt the company. Helping a competitor copy a product line is like stealing from us.

>> Yeah. I don’t think he deserves much of a bonus this year if he’s going to consider doing stuff like that. Don’t tell anyone you heard this from me.

>> Well, I think your comparison might be a little off. John does have about five years more experience than you do.

>> Really?

>> That’s what I learned when I was interviewing. And plus, he probably puts in about 50 hours a week to our 40. So he might be getting paid a little bit more, but you’ve got more of a life. He’s a great performer. He’s better than anybody else here.

>> I had no idea he put so much into his job. He is our best performer.

>> Yeah, and he’s been in the business forever.

>> That explains in part why he’s so good.

>> Yeah. So don’t you think he deserves a little bit more money?

>> When you put it that way, I have to agree. He’s a real asset to this company.

>> You know, I think that this company is very fair on rewarding performance. I feel like if I do my job well, I’ll be fairly rewarded.

>> Yeah. I guess I should just focus on doing my own job better, huh? Hey, maybe I’ll ask John to mentor me.

>> That’s a great idea. You know, maybe I should, too.

>> Thanks, Alex.

>> Yeah, man. Any time.