Answered step by step
Verified Expert Solution
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 research analyst for
Scenario 3 - Excel Based Use the scenario described below to answer the following questions. As part of your job as a research analyst for Google, you are 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 key factors, but you want to test your claim. You collect data on thousands of diflerent types of apps, some of which are free and others that the usee must pay for, to test your claim. Use this data to answer the following questions. Variable Descriptions: Installs: The total number of instlations or downloads of the app. Aating The consumer rating of the app en a scale from 1 to 5 stars wah 1 being the worst and 5 being the best: Pyice: The price of the app in dollars the "Hown fo" videos posted fo DXL. Estimate the following regressice equation using data on both the free and paid for apps (this data is on the sheet labeled "Free and Paid Apps" in the data) and fill in the estimated coetlicients. Hound the coefficient estimates to the nearest whole number. Hint, you might need ro click an the Modet 1 Inntalth =1+ Rating + Pries
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started