Question.186 - CDCCASE STUDY ASSIGNMENT Rising Insurance Premium for the Northeast You are a journalist for the New York Times. Your specialty is research. Some reader’s have written you complaining that their health insurance premiums are going up while that is not the case for people living in the Midwest. Upon calling several insurance companies (at your reader’s prompting), you were told the same thing – “Those residing in the Northeast compared to those residing in the Midwest live a more risky lifestyle in terms of alcohol consumption, driving habits, etc. As such their premiums unfortunately are going up while those living in the Midwest are not.” You have decided to research this and write an article for the newspaper to either confirm or refute this claim by the insurance companies. You suspect they are not telling the whole story and that the cost difference is most likely a function of the higher cost of living in the Northeast. Upon searching for various data sources to assist you in this effort, you ran across the Center for Disease Control’s “2010 Behavior Risk Factor Surveillance Survey.” This survey is conducted every 10 years and compiles the following information by state. Variable Label SMK Current cigarette smokers WEI Overweight (based on government height weight formula SED Sedentary lifestyle (less than three 20-minuted exercise sessions a week) ACT No leisure time activity off of the job ALC Binge drinking (five or more drinks on occasion) DWI Drinking and driving (after too much to drink) SEA Seat-belt use (occasionally or never) STATE U.S. State (alphanumeric) N Number of people surveyed In this study you will note that about 1,000 people from each state were randomly chosen to estimate the true population percentages. The file has been uploaded to blackboard. A printout of the dataset is attached. Please note that some data is missing for certain states and is denoted with an asterisk. Your task: First you will need to determine which states represent the Midwest and which represent the Northeast. You can find this information as defined by the U.S. government at the web address: www.census.gov/geo/www/us_regdiv.pdf Once determined you will then need to weight together the survey percentages based on population estimates for each state for the northeast and again for the Midwest. Use the 2000 population estimates. You can find these population estimates at the web address: http://quickfacts.census.gov/qfd/index.html Once all data is obtained and weighted together, you will then be ready to conduct some hypothesis tests to determine statistical significance. I suggest you create confidence intervals around the difference in percentages or averages. For example, you may want to determine if the percentage of those that binge drink is higher in the Northeast versus the Midwest and if so, is the difference statistically significant. In addition to using the CDC data you are required to also add some census data on income (median income) and education (% with bachelors degree) to the mix. But you must confirm it makes sense by correlating these measures with the risky CDC behaviors at a state level. In other words, you will conduct a correlation analysis where you correlate the census median incomes and percent with a bachelors degree versus the CDC smoking and alcohol consumption percentages. Are they correlated and if so how? Addiitonally read the lasted research on education on life expectancy. Google “Do Rich People Live Longer Harvard.” You may wish to cite portions of this study in your findings. In addition, I want you to consider the cost of living differences for the NE states versus the Midwest states. Google “Money Magazine Cost of Living Calculator” to find a tool to help you conduct this portion of the analysis. The true reason as to why we in the NE pay more is simply because our cost of living is more. Is that true? What do these calculators suggest? At this stage you will then be ready to create a final presentation. The presentations will need to display the raw data and findings in table and graph format using Excel. Be creative. (Hint: Perry loves presentations with nice backgrounds and graphics). Your final report will be in Power Point format with no more than 15 slides. Each Presentation must have at a minimum the following sections: Introduction Data Used and How Collected Analysis Steps Findings Conclusion On the last class each person will present their findings. Census Web Site Screen Shoot This is where you will go. At this location you can get mini reports by state including population estimates, median income values, education levels, etc. It is a vast source of free information by state. To find the map that defines what states represent Northeast versus the Midwest go to the PDF file located at: www.census.gov/geo/www/us_regdiv.pdf 2010 CDC Survey Data Regarding Behavior Risk
Answer Below:
nbsp xxxx nbsp xxxx nbsp xxxxxxx STUDY xxxxxxxxxx Rising xxxxxxxxx Premium xxx the xxxxxxxxx nbsp xxx are x journalist xxx the xxx York xxxxx nbsp xxxx specialty xx research xxxx Some xxxxxx rsquo x have xxxxxxx you xxxxxxxxxxx that xxxxx health xxxxxxxxx premiums xxx going xx while xxxx is xxx the xxxx for xxxxxx living xx the xxxxxxx nbsp xxxx calling xxxxxxx insurance xxxxxxxxx at xxxx reader xxxxx s xxxxxxxxx you xxxx told xxx same xxxxx ndash xxxx ldquo xxxxx residing xx the xxxxxxxxx compared xx those xxxxxxxx in xxx Midwest xxxx a xxxx risky xxxxxxxxx in xxxxx of xxxxxxx consumption xxxxxxx habits xxx nbsp xx such xxxxx premiums xxxxxxxxxxxxx are xxxxx up xxxxx those xxxxxx in xxx Midwest xxx not xxxxx nbsp xxx have xxxxxxx to xxxxxxxx this xxx write xx article xxx the xxxxxxxxx to xxxxxx confirm xx refute xxxx claim xx the xxxxxxxxx companies xxxx You xxxxxxx they xxx not xxxxxxx the xxxxx story xxx that xxx cost xxxxxxxxxx is xxxx likely x function xx the xxxxxx cost xx living xx the xxxxxxxxx nbsp xxxx searching xxx various xxxx sources xx assist xxx in xxxx effort xxx ran xxxxxx the xxxxxx for xxxxxxx Control xxxxx s xxxxx Behavior xxxx Factor xxxxxxxxxxxx Survey xxxxx nbsp xxxx survey xx conducted xxxxx years xxx compiles xxx following xxxxxxxxxxx by xxxxx nbsp xxxx Variable xxxxx SMK xxxxxxx cigarette xxxxxxx WEI xxxxxxxxxx based xx government xxxxxx weight xxxxxxx SED xxxxxxxxx lifestyle xxxx than xxxxx -minuted xxxxxxxx sessions x week xxx No xxxxxxx time xxxxxxxx off xx the xxx ALC xxxxx drinking xxxx or xxxx drinks xx occasion xxx Drinking xxx driving xxxxx too xxxx to xxxxx SEA xxxxxxxxx use xxxxxxxxxxxx or xxxxx STATE x S xxxxx alphanumeric x Number xx people xxxxxxxx nbsp xx this xxxxx you xxxx note xxxx about xxxxxx from xxxx state xxxx randomly xxxxxx to xxxxxxxx the xxxx population xxxxxxxxxxx nbsp xxxx The xxxx has xxxx uploaded xx blackboard xxxx A xxxxxxxx of xxx dataset xx attached xxxx Please xxxx that xxxx data xx missing xxx certain xxxxxx and xx denoted xxxx an xxxxxxxx nbsp xxxx task xxxx First xxx will xxxx to xxxxxxxxx which xxxxxx represent xxx Midwest xxx which xxxxxxxxx the xxxxxxxxx nbsp xxx can xxxx this xxxxxxxxxxx as xxxxxxx by xxx U x government xx the xxx address xxxx www xxxxxx gov xxx www xx regdiv xxx nbsp xxxx Once xxxxxxxxxx you xxxx then xxxx to xxxxxx together xxx survey xxxxxxxxxxx based xx population xxxxxxxxx for xxxx state xxx the xxxxxxxxx and xxxxx for xxx Midwest xxxx Use xxx population xxxxxxxxx You xxx find xxxxx population xxxxxxxxx at xxx web xxxxxxx nbsp xxxx quickfacts xxxxxx gov xxx index xxxx nbsp xxxx all xxxx is xxxxxxxx and xxxxxxxx together xxx will xxxx be xxxxx to xxxxxxx some xxxxxxxxxx tests xx determine xxxxxxxxxxx significance xxxx I xxxxxxx you xxxxxx confidence xxxxxxxxx around xxx difference xx percentages xx averages xxxx For xxxxxxx you xxx want xx determine xx the xxxxxxxxxx of xxxxx that xxxxx drink xx higher xx the xxxxxxxxx versus xxx Midwest xxx if xx is xxx difference xxxxxxxxxxxxx significant xxxx nbsp xx addition xx using xxx CDC xxxx you xxx required xx also xxx some xxxxxx data xx income xxxxxx income xxx education xxxx bachelors xxxxxx to xxx mix xxxx nbsp xxx you xxxx confirm xx makes xxxxx by xxxxxxxxxxx these xxxxxxxx with xxx risky xxx behaviors xx a xxxxx level xxxx In xxxxx words xxx will xxxxxxx a xxxxxxxxxxx analysis xxxxx you xxxxxxxxx the xxxxxx median xxxxxxx and xxxxxxx with x bachelors xxxxxx versus xxx CDC xxxxxxx and xxxxxxx consumption xxxxxxxxxxx nbsp xxx they xxxxxxxxxx and xx so xxx nbsp xxxxxxxxxxxx read xxx lasted xxxxxxxx on xxxxxxxxx on xxxx expectancy xxxx Google xxxxx Do xxxx People xxxx Longer xxxxxxx rdquo xxxx You xxx wish xx cite xxxxxxxx of xxxx study xx your xxxxxxxx nbsp xx addition x want xxx to xxxxxxxx the xxxx of xxxxxx differences xxx the xx states xxxxxx the xxxxxxx states xxxx Google xxxxx Money xxxxxxxx Cost xx Living xxxxxxxxxx rdquo xx find x tool xx help xxx conduct xxxx portion xx the xxxxxxxx nbsp xxx true xxxxxx as xx why xx in xxx NE xxx more xx simply xxxxxxx our xxxx of xxxxxx is xxxx nbsp xx that xxxx nbsp xxxx do xxxxx calculators xxxxxxx nbsp xx this xxxxx you xxxx then xx ready xx create x final xxxxxxxxxxxx nbsp xxx presentations xxxx need xx display xxx raw xxxx and xxxxxxxx in xxxxx and xxxxx format xxxxx Excel xxxx Be xxxxxxxx nbsp xxxx nbsp xxxxx loves xxxxxxxxxxxxx with xxxx backgrounds xxx graphics xxxx Your xxxxx report xxxx be xx Power xxxxx format xxxx no xxxx than xxxxxx nbsp xxxx Presentation xxxx have xx a xxxxxxx the xxxxxxxxx sections xxxx Introduction xxxx Used xxx How xxxxxxxxx Analysis xxxxx Findings xxxxxxxxxx nbsp xx the xxxx class xxxx person xxxx present xxxxx findings xxxx nbsp xxxxxx Web xxxx Screen xxxxx nbsp xxxx nbsp xxxx This xx where xxx will xx nbsp xx this xxxxxxxx you xxx get xxxx reports xx state xxxxxxxxx population xxxxxxxxx median xxxxxx values xxxxxxxxx levels xxx nbsp xx is x vast xxxxxx of xxxx information xx state xxxx nbsp xx find xxx map xxxx defines xxxx states xxxxxxxxx Northeast xxxxxx the xxxxxxx go xx the xxx file xxxxxxx at xxxx www xxxxxx gov xxx www xx regdiv xxx nbsp xxxx nbsp xxx Survey xxxx Regarding xxxxxxxx Risk xxxx nbsp xxxxMore Articles From Statistics
.ico)
.ico)
.ico)
.ico)
