Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 2. Creating charts and trendlines are important skills used in many careers.- I chose health services and nursing scenario
NEED HELP WRITING AN ESSAY
Tell us about your assignment and we will find the best writer for your project.
Get Help Now!Watch How to Create Trendlines and Scatterplots in Excel®.
Watch Week 4 Lynda.com® Video: Data-Analysis Fundamentals with Excel.
Create at least two visuals using your data from the data you chose in Week 2.
- Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual.
- Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual.
- Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. Explain why the model you chose is a better representation of your data.
Hints for Making an Effective Chart:
- Decide why you are making a chart from this data.
- Title each chart so that it aligns with the data and selected model.
- Create descriptive labels for both the x- and y axes.
- Resize the chart as needed so it can be viewed easily.
Your assignment will be graded using the Week 4 Grading Guide.
Select the Assignment Files tab to submit your visuals as either an Excel® file or a Word document.
The topic chosen is health services and nursing scenario
Why I chose this topic is because I find nursing very interesting. This is because nurses give their all in order to serve other people who are in need of help. Again, the topic of infants is one that really fascinates me. I find children very interesting to be around. When it comes to analysing data in a bid to find out the number of children born in a hospital, I will surely be interested. This topic analysis predicts the number of children to be born and this is an interesting topic to explore. It enables one to understand what people thinks about children and the general trend, if any that they are following when it comes to bearing children.
When doing the analysis, I hope to find a general trend that the data follows as years pass by. From a casual view at the data, the number of babies born in every year increases gradually as years move by. Therefore, after an analysis, I would get a relationship that the data follows. From the relationship if any, then it would be possible to predict the number of children that will be born in years to come as well as those in the past. From this data, a nurse or any hospital management staff can make a decision that is informed in a bid to improve the services in the health organization, keeping in mind the movement of data with time. It also allows them to understand the level of satisfaction of their customers.
Topic 1 – Health & Nursing
| Health Services and Nursing Scenario | |
| Topic 1 | Predicting the Number of Babies Born |
| Scenario 1 | Review the data involving the number of babies born in Humboldt County from 2006-2015. Predict the number of babies who will be born in 2018. |
| Year | Babies Born in Humboldt County |
| 2006 | 275 |
| 2007 | 280 |
| 2008 | 320 |
| 2009 | 366 |
| 2010 | 358 |
| 2011 | 336 |
| 2012 | 375 |
| 2013 | 390 |
| 2014 | 455 |
| 2015 | 487 |
Topic 2 – Criminal Justice
| Security and Criminal Justice Scenario | |
| Topic 2 | Predicting the Number of People Arrested for Drug Possession |
| Scenario 2 | Review the data involving the number of people arrested for drug possession from 2006-2015. Predict the number of people who will be arrested for drug possession in 2018. |
| Year | People Arrested for Drug Possession |
| 2006 | 1,519,760 |
| 2007 | 1,361,658 |
| 2008 | 1,321,824 |
| 2009 | 1,387,915 |
| 2010 | 1,179,728 |
| 2011 | 1,143,931 |
| 2012 | 1,237,708 |
| 2013 | 1,203,323 |
| 2014 | 982,169 |
| 2015 | 801,560 |
Topic 3 – Hum. & Sciences
| Humanities and Sciences Scenario | |
| Topic 3 | Predicting Student Smartphone Usage |
| Scenario 3 | Review the data involving the average number of hours students spent on their smartphones from 2002-2015. Predict the number of hours students will spend on their smartphones in 2018. |
| Year | Average Number of Hours Students Spend on their Smartphones |
| 2002 | 0.1 |
| 2003 | 0.75 |
| 2004 | 1 |
| 2005 | 1.5 |
| 2006 | 1.75 |
| 2007 | 5.5 |
| 2008 | 6 |
| 2009 | 9.3 |
| 2010 | 9.5 |
| 2011 | 8.9 |
| 2012 | 9 |
| 2013 | 11 |
| 2014 | 12.5 |
| 2015 | 10.6 |
Topic 4 – Social Sciences
| Social Sciences Scenario | |
| Topic 4 | Predicting Test Performance Based on Sleep |
| Scenario 4 | Review the data involving the number of hours students sleep and their average score on a test they take the next day. Predict the optimal hours of sleep students need the night before a test to achieve the highest score on the test. |
| Hours of Sleep | Average Score on Test |
| 4 | 55 |
| 4.25 | 40 |
| 4.5 | 53 |
| 4.75 | 59 |
| 5 | 60 |
| 5.25 | 63 |
| 5.5 | 66 |
| 5.75 | 75 |
| 6 | 70 |
| 6.25 | 72 |
| 6.5 | 80 |
| 6.75 | 77 |
| 7 | 85 |
| 7.25 | 90 |
| 7.5 | 100 |
| 7.75 | 95 |
| 8 | 88 |
| 8.25 | 85 |
| 8.5 | 74 |
| 8.75 | 88 |
| 9 | 90 |
| 9.25 | 87 |
| 9.5 | 86 |
| 9.75 | 95 |
| 10 | 82 |
Topic 5 – Business
| Business Scenario | ||
| Topic 5 | Predicting Fuji Apple Purchases | |
| Scenario 5 | Review the monthly data involving Fuji apples purchased at a large grocery store. Predict how many Fuji apples will need to be in stock to have available for the customers in December (month 12)? | |
| Month | Fuji Apples Purchased | Hint: When determining the solution to this question remember that amounts needed in a store will go up around holidays. Seasonality is a characteristic of a time series in which the data experiences regular and predictable changes that recur every calendar year. Any predictable change or pattern in a time series that recurs or repeats over a one-year period can be said to be seasonal. |
| 1 | 5,325 | |
| 2 | 5,648 | |
| 3 | 5,873 | |
| 4 | 9,842 | |
| 5 | 8,234 | |
| 6 | 9,421 | |
| 7 | 10,123 | |
| 8 | 9,784 | |
| 9 | 10,443 | |
| 10 | 9,564 | |
| 11 | 10,147 | |
Topic 6 – Education
| Education Scenario | |
| Topic 6 | Elementary Education: Math Skills |
| Scenario 6 | Review the data involving elementary students in Apache County who passed the AZ Merit Test from 2006-2015. Predict the number of students who will pass the AZ Merit test in 2018. |
| Fiscal Year | Students in Apache County who Pass the AZ Merit Test |
| 2006 | 12 |
| 2007 | 7 |
| 2008 | 14 |
| 2009 | 18 |
| 2010 | 25 |
| 2011 | 37 |
| 2012 | 33 |
| 2013 | 39 |
| 2014 | 45 |
| 2015 | 42 |
