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 research analyst for

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 research analyst for Google, you are interested in determining what makes an app successfuit in terms of the number downlosds, You believe that the rasing and the price of the app are key factors, but you want to test your claim. You collect dats on thousands of ditferent types of apps, some of which are free and others that the user must pay for, to test your claim. Use this data to answer the following questons. Yariable Descriptions: installs:-The total number of instillations of dowellads of the app. Aating. The consumur rating of the app on a scale feom 1 to 5 stars with 1 being the worst and 5 being the best. Price: The price of the spp in dollars Foe this quieition you wifl heed to download the Google Play Store Data and then use the data analysis tool pack in Excel no run a regression. Note, you will need to install the data analysis bool pack on your computer, If you have not run a regression before, please consult the regression section of the How-Tor videos posted fo Dox. You are concerned that the price variable is not statistically significant at the she significance level and you believe it is because you have data on so many free apps. You decide that you jast want to focus on the apps that are paid for. Estimate the lollowing regression equation usine data on only the poid for apps (this data is on the sheet labeled 'Paid only" in the data) and fil in the estimated coefficients. Plound the coetficient estimates to the nearest whole number. Hunt, you might need to click on the cells to get the full number. Do Nor enser the number in scientific Model 2: Instalts = + Rating Price

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Auditing

Authors: Karla M. Johnstone, Audrey A. Gramling, Larry E. Rittenberg

8th International Edition

0538477660, 978-0538477666

More Books

Students also viewed these Accounting questions

Question

Approaches to Managing Organizations

Answered: 1 week ago

Question

Communicating Organizational Culture

Answered: 1 week ago