The Concentration Variable

This exercise follows very closely to what we did in class in terms of analyzing a claimant database. First, you will need to download an Excel file that contain information on the claimants. This is “claimant_hw.xlsx.”Even if you don’t get the answers correct, I can still give you credit for trying. Don’t give up!1. [ 0 points – but please do it for the next step]. First, I’d like for you identify the state for each claimant. As we did in class, please take the left 2 digits of the claim_id variable for the first 3 states and the left 1 digit of the claim_id variable for observations in San Diego. This will identify the state “fip”. State fip 26 = Michigan, State fip 24 = “New Jersey”, State fip 25 = “Massachusetts”, State fip 6 = “California”. This will create a new “state” variable.Next, I’d like you to create a summary table of the Concentration Variable. To do so create a new tab in Excel (you can create a new tab by pressing the “+” button down where it says “claimant”.2. [4 points]. Create a summary table that has as columns, “State”, “Minimum Concentration”, “Mean Concentration”, “Maximum Concentration”, and “Number of Observations”.

Use the appropriate Excel Functions to create this table by state. Once you create this table, format it so that it looks presentable and paste into a Word document with a description of the table. You get 1 point for presentation of this table and 3 points for the correct answers.3. [4 points] In this next step, I’d like for you to run a regression of sicknesses (dependent variable) on concentration (independent variable). Present the key coefficient results in a table in Word. Describe the main slope parameter of interest in terms of its magnitude and significance. 3 points for the correct answer, 1 point for presentation and description of your results.4. [2 points] Add a scatter plot of sickness versus concentration to your Word document. Make it presentable and briefly describe what it shows. Please include a linear fit of the data on the graph (i.e., a line that runs through your data). 1 point each for correct answer and presentation. Get help and further assistance here.

Don't use plagiarized sources. Get Your Custom Essay on
The Concentration Variable
Just from $13/Page
Order Essay
Customonlineessays
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Why Choose Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

Customer Support 24/7

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Services we offer

You do not have to soldier through school on your own! We are what you need.

Essays

Essay Writing

Your high school and campus essays have never been easier to complete. At any time of the day, and any type of paper, look to us for professional help and maintain your grades. we are available 24/7 to solve your essay problems and give you constructive and lasting solutions. School just became easier for you because you discovered us. Forget about the struggles of writing essays and live in the moment as you should.

Research

Dissertation papers

some papers are not just simply papers. they require meticulous research and studies. you might need to go as far as choosing a sample group to perform your research on. we know how hard and time-consuming dissertation papers can be, but here is some good news; we have professionals that thrive in that field. let us work on your reserach, thesis and dissertation papers and ease the stress you would have. you can get the best grades at pocket friendly prices and without all the struggles.

Admissions

Admission and Business Papers

An admissions letter is an essay you will write before you join the institution. If you want someone who will present you as an irresistible candidate, look no further. We will write you the best paper that will get your foot right through the door. Your business proposals will also be handled by the best in the industry. You will be a testament to our services.

Editing

Editing and Proofreading

Our editorial team of professionals will take your papers through multiple checks to ensure that you have no errors, mistakes or cases of plagarism. Your paper will achieve professional status because you chose to trust expert. We also include citations and sources using the correct format as required by your institution. Whether you wat it in APA, MLA, Chicago or Harvard, we have specialised in all writing formats.

Writing

Rewriting services

sometimes, you spend hours and hours working on a paper but its just not giving the content as you had hoped. if this is what you feel, you shouldnt hand in that paper. instead, let us help you rewrite it so that it says what you had originally intended. all you need to do is allow us to read your first draft, collect your main points and ideas and tailor it to make sense and give you what you were hoping for. as you develop your writing skills, don allow your grades to fumble. that is why we are here for you.