Price forecasting model in Excel
$250-750 AUD
货到付款
We operate an insurance brokerage.
Our challenge is to create a simple insurance price forecasting tool based on historical pricing data.
Specifically:
1. We have an excel sheet with 14,073 rows and 7 columns.
2. Columns are; insurance price, Vehicle Make, Vehicle Model, Vehicle Year, Driver Gender, Driver Age, Driver Location (name of an Australian State).
3. The rows are insurance prices.
We want to create a forecasting model using multivariate regression, or another approach, to be able to forecast what the dependant variable (insurance price) might be based on the various independent variables, such as vehicle make, model, year and various driver characteristics.
The reason why we need help is that the data has a large number of categorical variables. There are 43 different types of vehicle makes and 434 different vehicle models. As a result, we don't know how to program the dummy variables. Using 0/1 dummy variables would likely fail.
Data:
- We are using a small dataset in an excel sheet.
Data Preprocessing:
- No cleaning or preprocessing of the data is required.
Intended Usage:
- The price forecasting model is intended for us being able to offer instant quotes to customers.
When customers apply for insurance through our brokerage, we want to be able to instantly quantify how much the policy might cost, before we proceed to obtaining a legally binding quotation from the insurance company.
Skills and Experience:
- Strong proficiency in Excel, regression and data analysis.
- Experience in developing forecasting models.
项目ID: #37596247
关于项目
授予:
Hello, I am Faisal and I am excited to learn more about your project and assist you with developing a simple insurance price forecasting model in Excel. With my extensive background in statistics and data analysis, as 更多
有31名威客正在参与此工作的竞标,均价$452/小时
Hello, I am an Excel and VBA programming expert and I can perfectly assist you and I can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including 更多
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 2 days
I CAN HELP YOU WITH FORCASTING MODEL USING EXCEL OR SPSS. In terms of Analysis task, I provide highest quality services in the following areas of Statistics and E-commerce. So get your job done here! I can do: Survey d 更多
Hello, I am an experienced data scientist with a proven track record in developing sophisticated forecasting models, particularly in the insurance industry. I have successfully tackled challenges similar to yours, inc 更多
I am here to offer Financial Projections, excel price forecasting,Financial Forecasting, Cashflows, and Financial Plans. So, Get financial modeling & projections that help you set a financial strategy. Here is the list 更多
Hello there! My name is Muzafar and I am a professional freelancer specializing in providing top-notch expertise in Data Analysis, Excel, Content Writing, and PPT creation. With a passion for precision and creativity 更多
Hi, I can do this job quite efficiency. I can start it right now. Let's discuss further through chat. Thank you
I'm electrical and Electronics Engineering working perfectly in mechanical engineering and Architect working intellectually in any electrical and Electronics Engineering
I can work for you at best level, with lowest cost, i have afar experience in excel. lets talk further via chat. thank you.
Hello there! My name is Syeda and I'm excited to hear that you need help creating a simple insurance price forecasting tool based on historical pricing data. With more than 15 years of experience in Excel and related t 更多
I want this bid because it aligns perfectly with my expertise, vision, and commitment to delivering outstanding results. Me and team has a proven track record of success in similar projects, and we're passionate about 更多
Hello there! My name is Sanhati and I am a business planner with extensive experience in Excel and regression. I understand your project well and would be more than happy to help you create a simple insurance price fo 更多
"Hey ,I'm interested in your data entry project.I have experience, attention to detail,and can start right away. Let's discuss your requirements and my rate . Looking forward to working with you! Thanks, shashank "
Hi, I am excited to propose my services for your insurance price forecasting tool project. With expertise in data analysis and machine learning, I plan to utilize a combination of one-hot encoding and multivariate re 更多
Dear client, I have have 10 years of experience in data analyst. Please initiate chat for further discussion. Regards Narendra
Hello, We propose the development of a robust and user-friendly insurance price forecasting tool that leverages historical price data to predict future insurance premiums accurately. This tool aims to assist insurance 更多
Hello, I am eager to take on your freelance project to develop a comprehensive insurance price forecasting tool using historical pricing data from your Excel sheet. Leveraging my strong proficiency in Excel, regressio 更多