Reference no: EM131443941 , Length: 4
You analyzed a pre-intervention elementary school asthma database from the perspective of a public health informatician. This week, you will review the data set in more detail and discuss the tools informaticians use. For the asthma data summary, you will use your Excel Spreadsheet and Pivot Table reports.
You will then answer the following questions in the form of a 3-4-page summary statement that includes the data as well as an interpretation of the findings. The Pivot Tables need to be embedded in your report to explain the summary results.
What summary results do your pivot tables demonstrate about this grade school population of students? Use the following questions to prepare your paper.
Data Frequency Questions:
Introduction:
Begin with an explanation of the tools of informatics, including spreadsheets, relational database technologies, and integrated statistical packages. Why are these tools and technologies so important when managing large databases of public health informatics?
Database Analyses:
Are there more males or females in the survey population?
Which condition has the highest frequency?
Which month had the highest number of students with breathing difficulties?
Which school had the highest frequency of students with bronchitis?
Which gender has the highest frequency of asthma?
How many students answered yes to Reactive Airway Disease (RAD)?
What is the percentage of students with RAD that have been prescribed medication?
Which zip code has the highest number of students living in it?
Of that zip code, which condition had the highest frequency?
How many students answered yes to all four conditions: asthma, RAD, bronchitis, and wheezing?
Based on all four conditions and zip code, are the conditions evenly distributed among the survey population?
Does one school have more students in the affected zip codes and with all four conditions than the others do?
Summary:
Explain your data analyses results and describe what data quality assurances you applied to ensure your results are accurate.
Give reasons and examples in support of your responses. Cite all sources using APA format.
Attachment:- Asthma_survey.rar
Law of equalising the weighted marginal means
: law of equalising the weighted marginal means
|
Two components of the tax agent services
: FNSBKG404A - List the two components of the tax agent services legislative package, including where you would find information about them - Describe the purpose of the TPB and list three (3) ways you can ensure you comply with the TPB registration r..
|
What is economy-wide human capital
: Consider an economy with total population of 200. Let these 200 workers be equally divided between two groups: the rich and the poor. The poor have less human capital per person than the rich do.
|
Customers wait on average before being processed
: Currently customers come in at the rate of 4 per hour and are processed at a similar rate. On average 8 cars are waiting to be processed, 4 needing routine repairs and 4 needing major repairs. People are served on a first come first serve basis. (..
|
Which condition has the highest frequency
: You analyzed a pre-intervention elementary school asthma database from the perspective of a public health informatician. This week, you will review the data set in more detail and discuss the tools informaticians use. For the asthma data summary, ..
|
Of the various sales and operations planning options
: Of the various sales and operations planning options, which do you think is the best approach? Why? Provide an example supporting your selection.
|
Conduct a non-intrusive breaching experiment
: Conduct a non-intrusive "breaching experiment", wherein you attempt to validate the existence of a particular norm. This may include singing on the bus, singing in an elevator, not talking to anyone for a day, or any other informally deviant activ..
|
Analyse the project and draft a memo
: ACC00152 Business Finance Assignment: Memo to Management. Your boss, Widget's CFO Diane Jones, has asked you to analyse the project and draft a memo to the Board of Directors providing recommendations, along with supporting analysis
|
What costume design tells the viewer about that character
: Like sets and lights, costume design not only helps to tell the story, but also gives us insight into the individual characters (without them ever having to speak). A character's costume may indicate gender, position and status, occupation, occas..
|