Subject is Econometrics and Big Data. Read and answer the questions. Use Excel to answer the...

Transcribed Image Text:

Subject is Econometrics and Big Data. Read and answer the questions. Use Excel to answer the questions Database: An important chain of stores has a large number of branches across Canada and the United States. The manager has some data on a sample of 342 branches. Here are the variables studied: Profit- Profit for the year 2016 (in thousands of dollars). Note that a negative profit is a loss. Budget- Advertising budget for the year 2016 (in thousands of dollars). Location Global assessment of the location of the branch. This variable was developed from different criteria: the size of the population living near the branch, the median income of this population, access by public transport, the number of parking spaces available, etc. These criteria were measured and weighted so as to obtain an overall rating between 0 and 100, 100 being the highest rating representing an excellent location. Direction- Branch management quality index: 1-acceptable, 2-good et 3 = excellent. Comp Presence of a competitor within a radius of 5 km: 0-no competitor, 1-présence d'un compétiteur Questions. 1. Indicate the type of each variable in the database. 2. Find the proportion of branches making losses. 3. Comment on the distribution of the advertising budget. 4. Find the proportion of branches having a competitor within a 5 km radius. 5. Find the average profit for the branches for each management quality index (acceptable, good and excellent). 6. Find the proportion of branches making an annual profit (in thousands of S) exceeding 100 among those located in an area without competitors. 7. Find the proportion of branches with a competitor within a 5 km radius, with an excellent management quality index. 8. Find the proportion of branches making losses among those having a location score less than 50. Subject is Econometrics and Big Data. Read and answer the questions. Use Excel to answer the questions Database: An important chain of stores has a large number of branches across Canada and the United States. The manager has some data on a sample of 342 branches. Here are the variables studied: Profit- Profit for the year 2016 (in thousands of dollars). Note that a negative profit is a loss. Budget- Advertising budget for the year 2016 (in thousands of dollars). Location Global assessment of the location of the branch. This variable was developed from different criteria: the size of the population living near the branch, the median income of this population, access by public transport, the number of parking spaces available, etc. These criteria were measured and weighted so as to obtain an overall rating between 0 and 100, 100 being the highest rating representing an excellent location. Direction- Branch management quality index: 1-acceptable, 2-good et 3 = excellent. Comp Presence of a competitor within a radius of 5 km: 0-no competitor, 1-présence d'un compétiteur Questions. 1. Indicate the type of each variable in the database. 2. Find the proportion of branches making losses. 3. Comment on the distribution of the advertising budget. 4. Find the proportion of branches having a competitor within a 5 km radius. 5. Find the average profit for the branches for each management quality index (acceptable, good and excellent). 6. Find the proportion of branches making an annual profit (in thousands of S) exceeding 100 among those located in an area without competitors. 7. Find the proportion of branches with a competitor within a 5 km radius, with an excellent management quality index. 8. Find the proportion of branches making losses among those having a location score less than 50.

Answer rating: 100% (QA)

1 Ind icate the type of each variable in the database Pro fit is a quantitative variable budget is a quantitative variable location is a quantitative ... View the full answer