Question: Scenario 3-Excel Based Use the scenario described below to answer the following questions. As part of your job as a reseurch analyst for Googlo, you
Scenario 3-Excel Based Use the scenario described below to answer the following questions. As part of your job as a reseurch analyst for Googlo, you aze interested in determining what makes an app successful in terms of the number downloads. You believe that the rating and the price of the app are kry factors, but you want to test your elaim You collect data on theusands of diflerent types of apps, some of which are free and others that the user must pay foc, to test your claim. Use this data to answer the following questions. Varlable Descriptions: instals: The total number of instillations or downloads of the app Rating. The consumer rating of the app on a scale from 1 to 5 stars with 1 being the worst and 5 being the best. Price: The peice of the app in dollars For this question, you will need to download the Google Play Store Data and then use the data analysis fool pock in Eveel fo run a regression. Nate, you will need to insfall the data analysis fool pack on your computec, if you have not run a regression before, please consult the regrestion section of the How To" videos posted to Dat. Estimath the following regression equation using data on both the freo and paid for apps (this data is on the sheot labeled "Free and Paid Apps" in the date) and fil in the estimated coetlicitnts. Aosud the coetficient estimates to the nearest whole number. Hint, you might need to click on the Model 2: Invtallis = + Roting
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
