Order Description Using the Excel sheet, review the provided data to answer the following questions (if your good at math, finance, analytics, and excel sheets this is the task for you) 1 Fill in the Open Rate column 2 Create a Ma...
Order Description
Using the Excel sheet, review the provided data to answer the following questions
(if your good at math, finance, analytics, and excel sheets this is the task for you)
1 Fill in the Open Rate column
2 Create a Male/Female Variable
3 How many people renewed in 2022?
4 How many peoeple renewed with a resale rate above 40%?
5 Which year had the highest renewal rate?
6 Run logistic regression (using Solver Add In)
7 Create the renewal probability in the projection dataset?
8 How many renewals do you expect in 2024?
9 What is the projected renewal rate in 2024?
10 Create a summary tab for your projections (use for insights)
please put all answers on excel sheet
For privacy and security, delivered files are not available for public download. The student who placed this order can sign in to access the delivered work from their dashboard.
Post your assignment and receive offers from verified writers in your subject area.
Post a new assignment Back to latest orders