Subject is Econometrics and Big Data. Read and answer the questions. Use Excel to answer the...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
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
Posted Date:
Students also viewed these accounting questions
-
Getting a college education today is almost as important as breathing and its expensive! It is not just the tuition, room, and board; textbooks are expensive too. It is very important for students,...
-
It is required to design a BPF with the following specifications -0.02 < |H(ejw)l < 0.02, 0<= |w| <=2n 0.95 < |H(ejw) < 1.05, ,3n <= Iw| <= 0.7n, -0.001 < |H(ejw)| <...
-
How would decisions about managing forests for carbon sequestration be affected by the speed at which wood building material decay?
-
a. Suppose that hedonic wage studies indicate a willingness to pay $50 per person for a reduction in the risk of a premature death from an environmental hazard of 1/100,000. If the exposed population...
-
Is there a difference between ethical obligations and legal obligations in regards to online privacy?
-
Morvarid Kashanchi and her sister, Firoyeh Paydar, held a savings account with Texas Commerce Medical Bank. An unauthorized withdrawal of $4,900 from the account was allegedly made by means of a...
-
What are common-size financial statements and how are they used?
-
Using Excel or another program, estimate the linear OLS demand regression for the iTunes focus group data in the Managerial Solution. What is the R2? What are the coefficient estimates, the standard...
-
Question 1 Write down correct answer for the corresponding statements provided. Column A (Marks: 10) Q.1.1 Shows users how to complete a task that was not technically viable or appeared to be Q.1.2...
-
Submag, Inc., uses direct-mail promotion to sell magazine subscriptions. Magazine publishers pay Submag $3.12 for each new subscription. Submags costs include the expenses of printing, addressing,...
-
Below is given frequency distribution of marks (out of 100) obtained by the students. Calculate mean marks scored by a student. 0- 10 - 20- 30- Marks 10 20 No. of Students A B D 3 5 7 48.75 marks...
-
You have set a financial goal of having $3,500,000 saved by retirement. If you plan to work for the next 40 years, how much would you need to save at the end of each year if you expect an average...
-
Describe the "levels of evidence" and provide an example of the type of practice change that could result from each. discuss how you will use these levels of evidence to convince stakeholders and...
-
The CAC40 has a Sell price of 4998 and a Buy price of 5000. You open a long (Buy) CFD trade of 10 contracts, equal to 10 euros per point. The price increases to a Sell price of 5010 and a Buy price...
-
The next two questions refer to the below information: A) The trading desk at the Federal Reserve sold $700 million in T-Bills. If the current reserve requirement is 7%, how much will the money...
-
(a) A rigid tank contains 1.30 moles of nitrogen, which can be treated as an ideal gas, at a pressure of 27.8 atm. While the tank and gas maintain a constant volume and temperature, a number of moles...
-
MEAN AND STANDARD DEVIATION HISTOGRAM SPSS MEAN AND HISTOGRAM OUTPUT (ATTACHED) 1. PROVIDE DESCRIPTION AND EXPLANATION REPORT IN THE ATTACHED RESULT IN SPSS PROVIDED 2)ANALYZE CURV AND THE DIAGRAM 2)...
-
DC has unused FTC carryover from 2017 in the separate category for GC income as the result of income generated by a foreign branch. The income was foreign source general category income. In 2018 the...
-
The graph below shows computer links between an official vote-tallying center at vertex 1 and several precincts. For the sake of secrecy, links can be made secure, but since this is an expensive...
-
Finish the proof of Theorem 1, that is, if \(G\) is a connected graph with \(n\) vertices and \(n-1\) edges, then \(G\) is a tree.
-
Using the work already done in creating the Spanning Tree One Step function, write a full, simplified version of the complete undirected spanning tree algorithm, without the options, which takes the...
Study smarter with the SolutionInn App