Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started