I am needing to use Rstudio and/or Excel to answer these questions.
Please include either your R-Script or Excel file used to answer these questions. We're using the same dataset as the M4 HW. Here is the datasetPreview the document and here is the codebookPreview the document.
1. Create groupings for education and age. For education, classify each individual into one of the following groups: no degree, GED/diploma,bachelor's degree,Masters or doctorate,all others. For age, classify each individual as 18-29,30-39,40-49,50-59,60-69, or 70+. You may do this by creating a series of binary/dummy variables (0 or 1; definitely do this if you are using Excel) or creating one categorical/factor variable to use in the regression. If you're using binary variables, don't create a dummy for the 18-29 year old and no degree groups. If you're using a factor variable, make sure to specify this in the regression in R.
2. Run a linear regression to predict the annual out of pocket expenditures for an individual using the following [login to view URL] constant term will automatically pop up in the regression. You don't need to add it to the regression or Script.
Out of pocket expenditures=Constant+age+education+has private insurance+expected total payments
a. Are all four of the independent variables significant?
b. Predict the out of pocket expenditures for a 42 year-old individual with a bachelor's degree, private health insurance, and annual total payments of $10,000.
c. What are two more variables in the dataset that you think would be related to out of pocket expenditures? Why?
d. Add the variables to the regression and provide the results. Were your predictions correct?
3. For each age group defined in question 4, determine the mean number of medications prescribed, percentage of individuals ever diagnosed with cancer (exclude all individuals who are NIU from this percentage), percentage of individuals in very good or excellent health (again excluding all individuals who are NIU), and median total income. Then, create a table to visualize these results. Note: Even though I plan on using R for the assignment, I will likely construct the table in Excel.
Being a data analyst and proficient in R, I will accurately do the task in one day
Relevant Skills and Experience
Expert in data analysis using various software
Hello
I am an expert in statistical analysis in Excel and R. I can conduct various test and interpret the results in APA styles. I have 7 years of experience in this field. I have published various research papers and worked on various dissertation. I can do this job in 1-2 hours .. Please contact me.
$10 USD në 1 ditë
4,7 (37 përshtypje)
4,5
4,5
10 freelancers are bidding on average $38 USD for this job
Hello
I can achieve your project perfectly using R within next few hours
I master R programming , statistics , data mining , linear regression , clustring and classification using Kmeans-knn
time series using arma arima , ar ma ,sarima
decision tress and random forest , naive bayesian
please check my work history and my portfolio for more details
best regards
Hi,
I'm a data scientist with over 5 years of experience working on machine learning, data science and AI applications. Recently graduated with a Master's in Data Science from Trinity College Dublin, I hold proficiency in R and Python both. I am available to assist you with this work.
Thanks,
Tousif
Dear client?
I highly value professionalism and hold myself strictly accountable to represent my client’s work. I aim to form a long-term working relationship.
For 3 years I’ve worked as a statistical analyst and so I am accustomed to working with different tasks related to SPSS and Excel.
I have a deep passion for research and this guarantees you that all of my work is 100% original. I also ensure that I complete the work within the agreed time and a standardized rate.
Please, consider my bid and Click on the following link to see my previous works https://www.freelancer.com/hireme/kelvinm094.
Thank you.
Hi,
I've been developping statistical models using R for several years and would like to work on your project. I assure you you will be impressed by the quality of my work as did every single client of mine. I'm looking forward to hearing from you.