Find Jobs
Hire Freelancers

Excel, SAS health care model program

min $50 USD / hour

Closed
Posted almost 6 years ago

min $50 USD / hour

Actuarial consulting firm looking for SAS, Excel program to create a model. This is a simplified project. The ultimate project will include something similar plus a flat file with 600,000 records that will need a number of calculated fields added, some statistics generated, and some logic programed with output graphs and tables. Simplified project Input: Two Excel Workbooks with 5 worksheets each will contain the input data. Process: A. Only use the Renewing plans – row 17 B. For each plan match the plans in 2018 that were there in 2017 for each company. C. Pull data from: 1. The 2018 Metal level (row 14) 2. The 2018 rate increase (row 26) 3. The 2018 members (row 48) 4. The 2017 members (row 48) D. Calculate the membership change from 2017 to 2018 (2018 membership – 2017 membership). Output: A. Create a scatter graph for each metal level of the membership change versus the rate increase with the trend line, slope, and R2 (Coefficient of determination). B. Provide a multiple variant regression showing the change in membership based on the metal level and rate increase showing at least: a. R2 (Coefficient of determination); b. Adjusted R2 c. Coefficients; d. Standard error; e. T stat; and f. P value.
Project ID: 17107666

About the project

27 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
27 freelancers are bidding on average $53 USD/hour for this job
User Avatar
Hello, I can help with you in your project Excel, SAS health care model program. I have more than 5 years of experience in Data Processing, Excel, Statistical Analysis, Statistics, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$50 USD in 40 days
4.9 (441 reviews)
8.3
8.3
User Avatar
Hello, I am Highly experienced excel expert and VBA Developer I have built lots of financial models and can help to build for you one too If you will be interested, contact me Thanks & Regards
$58 USD in 40 days
5.0 (154 reviews)
8.2
8.2
User Avatar
Hi, can you please provide sample file, it will makes things easier to understand. Best regards, Issam
$50 USD in 15 days
4.9 (314 reviews)
7.8
7.8
User Avatar
Hi, I am working as freelancer in areas of statistics, data analysis, econometrics, economics last 18 years. I working with students, postgraduates students, academics, businessmen, managers, consulting companies and so on. I have strong mathematical, statistical, economical and psychological background. I am familiar with R, Stata, SPSS, Excel, Mplus, Eviews, Gretl, Problog, MiniZinc and other software. Regards, Alex
$55 USD in 40 days
5.0 (68 reviews)
7.8
7.8
User Avatar
Hello, I develop modules for Stock Exchange Traders in Microsoft Excel. The models manage their trading process and analyze the symbols based on trading ratios and personal algorithms. In some projects, I implemented methods like Monte Carlo simulation, S-Curve and more. About me: I am a financial expert and a guru in Excel and Excel-VBA/Macro. I come up with creative and sophisticated financial & statistic models in a simplified and logical manner having extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Also, I am an expert in preparing proposals for investors, including pitch decks, business plans, feasibility studies, due diligence, and financial projections with dynamic scenarios. With my knowledge of finance and my skills in Microsoft Excel, I construct various financial models, including business valuation methodology and ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.). These models present complex business components straightforwardly and logically manner.
$75 USD in 40 days
4.9 (94 reviews)
7.3
7.3
User Avatar
Hi, I am experienced on Microsoft Access , Excel VBA , Statistical Analysis etc. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
$50 USD in 40 days
4.9 (171 reviews)
6.8
6.8
User Avatar
Hello! Being one of the most experienced Statistician/Mathematician on this website with around half thousand excellent reviews and proven track record, I would love to work on this project. I am experienced data analyst also familiar with almost all statistical softwares including SPSS, R, Stata, Eviews, Mathematica, SAS, Weka, Minitab, Python and Matlab etc. Please reply back to discuss further. Thank you!
$58 USD in 40 days
4.8 (33 reviews)
6.2
6.2
User Avatar
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in many data analytics projects involving SAS & R. Also I have worked in projects involving Excel (Pivot Table, Macros) and VBA. I believe I have enough expertise in R to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh
$50 USD in 40 days
5.0 (54 reviews)
5.9
5.9
User Avatar
Hello. I have good skills in Data Processing, Excel, Statistical Analysis, Statistics, Visual Basic, etc. Contact me please. Thanks.....................................................................
$55 USD in 40 days
4.8 (99 reviews)
5.9
5.9
User Avatar
Dear Employer Hope you are doing well Coming to your project scope we will develop your SAAS health care program to create model where there will be input section, process and output section I have read the details mentioned in projects scope and we have few queries which we want to share with you like types of user and which technology you will prefer for development of your application we have team of exp developers and user interface designer in our company with 4-7 years exp and we will deliver you quality and professional work from our team I will be waiting for your reply asap Warm Regards Sam
$50 USD in 40 days
4.3 (5 reviews)
5.7
5.7
User Avatar
Hi there, I am an Excel expert, with more than 7 years of experience in advance excel skills, i am also a Financial analyst and MBA in Finance and have done numerous analysis and prepared various excel sheets for the purpose for analysis. I am also an Acturial Science student and i have topped my country in 2 out of 7 papers i have given, which give me an extra edge in understanding your requirements in a bettter way. I will provide you an excel sheet exactly the way you have described in your job posting. Message me so that we can have a detail discussion on the project and the timeline. Thank you
$50 USD in 12 days
4.8 (17 reviews)
4.2
4.2
User Avatar
Hello, I'm an Excel Expert but I have several Statistical Knowledge what, I think, is necessary for this project. I'd like to talk with you to ensure I'm the adecuate person for this project. Thank you very much for your time.
$50 USD in 40 days
5.0 (11 reviews)
2.8
2.8
User Avatar
Thank you for posting a detailed description of the project. I've been programming in VBA since 2005 which include numerous office system and ERP integration; I can do this project successfully. Could you send me a sample of the input data? Best regards Munir
$55 USD in 40 days
5.0 (4 reviews)
1.9
1.9
User Avatar
I can work with Excel and SAS
$50 USD in 20 days
5.0 (1 review)
0.4
0.4
User Avatar
I read your description carefully and understand what you want. I'm 100% sure, I will complete your project perfectly with high quality work. You will get satisfied results from me. Thank you.
$50 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am in Civil Engineering and i always use excel VBA and macros to program the excel sheet to do things related ti engineering similar to your requirements i have a great experience in excel
$55 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have ever joined sas course, so i know little bit abiut sas. please considerate my proposal, thank you.
$55 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can help you with in your projects Excel, SAS, health care model program. we have 8 years of experience in Data processing and Excel, SAS. Success fully implemented lot of projects.
$50 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have good experience with sas data manipulation and analysis using stats. will be available to take up this project immediately. looking forward to hear from u.
$53 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello, i'am a statistician and data manager of some research. I have experience helping undergraduate, master and PhD student to conduct data analysis.
$55 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Payment method verified
Member since Jun 4, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.