Posted: March 5th, 2023
There are a variety of tools that an epidemiologist might have at his or her disposal. The most common tools that are used in the field are SAS, SPSS, EpiInfo, R, and many others. These require significant time and diligence to become proficient at each of these statistical tools. However, almost every office has Microsoft Excel, Numbers (the Mac equivalent), or Google’s Excel-like product.
Often times, epidemiological calculations can seem/appear intimidating. However, if you let the excel document do the work for you then you do not have to worry about making errors in simple math. Please download the attached Microsoft Excel spreadsheet. You will be doing the following:
Calculating:
Graphing:
You will need to go to the Census Bureau(https://data.census.gov/) then click on Advanced Search then click on Geography. In the area marked state, county, or place, type your community or a community near you and select enter. You are going to want information from a table that contains Age and Sex in the title.
Please see attached file
SOLUTION
Excel can perform basic statistical functions such as calculating means, standard deviations, and confidence intervals, and it can also generate graphs and charts to display data. It’s also useful for organizing and cleaning data before importing it into more advanced statistical software. However, it’s important to note that Excel has some limitations in terms of data management and statistical analysis compared to specialized software. For example, Excel may not have the capability to handle large datasets, and some statistical functions may not be as robust as those in specialized software
Place an order in 3 easy steps. Takes less than 5 mins.