MSCI152 Coursework 2023/24 A start-up is considering to launch a new game for mobile phones, so they want to analyse demand for puzzle games on Google Playstore Market. They have brought you in, as a Business Analytics expert, to analyse existing apps and their downloads. You have been provided with data in an Excel file "puzzles.xlsx". It contains a sample of applications from the "Puzzles" category. The data description is as follows: • App Name - application name • Rating - rating of an application • Rating Count - number of ratings • Maximum Installs - number of downloads, cumulative • Free - variable, indicating Free or Paid app (TRUE/FALSE) • Price - price in USD • Released - date of the release • Last Updated - date of the last update • Ad Supported - categorical variable, indicating in app ads (TRUE/FALSE) • In app purchased - categorical variable, indicating in app purchases (TRUE/FALSE) • Editor Choice - categorical variable, indicating "Editor Choise" mark (TRUE/FALSE) You are asked to 1. Produce MSCI152 Coursework 2023/24

A start-up is considering to launch a new game for mobile phones, so they want to analyse demand for puzzle games on Google Playstore Market. They have brought you in, as a Business Analytics expert, to analyse existing apps and their downloads. You have been provided with data in an Excel file

"puzzles.xlsx". It contains a sample of applications from the

"Puzzles" category. The data description is as follows:

• App Name - application name

• Rating - rating of an application

• Rating Count - number of ratings

• Maximum Installs - number of downloads, cumulative

• Free - variable, indicating Free or Paid app (TRUE/FALSE)

• Price - price in USD

• Released - date of the release

• Last Updated - date of the last update

• Ad Supported - categorical variable, indicating in app ads (TRUE/FALSE)

• In app purchased - categorical variable, indicating in app purchases (TRUE/FALSE)

• Editor Choice - categorical variable, indicating "Editor Choise" mark (TRUE/FALSE)

You are asked to

1. Produce a simple dashboard in Excel that summarises the performance of applications in this category on Google Playstore Market;

2. Construct a multiple linear regression model to predict downloads for puzzle games and present the results of your analysis in a Management Report.