Premium Essay

4533

In:

Submitted By cassieeissc
Words 654
Pages 3
Fall 2015 QMB 6358 Indicator Variable Assignment

An “answer collection” mechanism will appear on Canvas shortly

One

The data set GrocSalesMall.xlsx contains information on the annual sales of 25 stores in a grocery chain. In the file are:

Sales Last year’s sales per store in $1000 units
Customers Number of Customers last year (in 1000s)
Mall 1 = store located at a mall, 0 = otherwise

To do: 1. Create a scatterplot between Sales and Customers. Use different symbols for the Mall and nonMall Stores

2. Run a regression of Sales on number of customers

3. Run a regression of Sales on both variables. a. Interpret the coefficient on the Mall variable b. Is this coefficient significant? c. Is the regression in part 3 an improvement on the one in part 2? Look at the change in R2 and adjusted R2. d. Show what is really “going on” in the regression by deriving the equation for sales in mall stores and for sales in non-mall stores.

A: For the same number of customers, stores in a mall have an average of 202.573 more sales than stores outside of malls.
B: This is significant (t=2.711 and p-value = .013)
C: R-square increased by 0.092 and adjusted R-square by 0.083.
D: Non mall: Sales = -82.464 + 9.505 Customers In Malls: Sales = 120.109 + 9.505 Customers

4. Create an interaction variable for Customers and Mall and add it to the regression. e. Interpret the coefficient on the interaction variable f. Is this coefficient significant? g. Is the regression in part 4 an improvement on the one in part 3? Look at the change in R2 and adjusted R2. h. Show what is really “going on” in the regression by deriving the equation for sales in mall stores and for sales in non-mall stores.

A: For stores in a mall, each 1000 extra customers

Similar Documents

Premium Essay

Smartphone

...importance to smartphone take-up not because they ignite consumers’ imaginations, but rather because they present arguably the first truly relatable service that older consumers and those otherwise uninterested in smartphones and smartphone applications have a genuine incentive to engage with.” – Samuel Gee, Technology Analyst In this report we answer the key questions: • • • • What does the increasing prevalence of bring your own device (BYOD) schemes predict about smartphones sales? How important will mobile wallets become? What can be done to increase smartphone take-up by older consumers? How can the remaining younger consumers be brought to smartphone ownership? BUY THIS REPORT NOW VISIT: store.mintel.com CALL: +44 (0) 20 7606 4533 0800 095 9094 +1 (312) 943 5250 +61 (0) 2 8284 8100 EMAIL: oxygen@mintel.com APAC Americas Brazil EMEA Mobile phone retail has been dominated in the years immediately leading up to 2012 by smartphone handsets and services. However the explosive growth seen between 2010 and 2012 has now slowed to a trickle as prime demographics have become saturated. For retailers and manufacturers of smartphones now, the most pressing issue is how to spread ownership through to older consumers with little knowledge or understanding of the proposition. This report examines: • • • • • Which smartphone operating systems are owned by consumers Which smartphone features consumers find most valuable and useful What the most important factors were in consumers...

Words: 335 - Pages: 2

Premium Essay

Math533 Part a

...PROJECT A: EXPLORATORY DATA ANALYSIS Introduction: A. This report is a statistical analysis of a chain of department stores called A.J. Davis. The project will consist of a sample of (50) credit customers and consist of (5) variables: Location, Income, Size of the household, Years lived in the location, and Current credit balances on the store’s credit card. Single Variables B. The 1st single variable for review is the Credit Balance, which is a quantitative variable. In the descriptive Statistics will show the central tendency and measures of dispersion. Descriptive Statistics: Credit Balance($) Variable Mean StDev Variance Minimum Q1 Median Q3 Maximum Credit Balance($) 3970 932 868430 1864 3109 4090 4748 5678 N for Variable IQR Mode Mode Credit Balance($) 1638 3890 2 Due to the bell-shaped curvature in the graph shown above, the customer’s credit balance will show a normal distribution. The highest frequency of credit from the customers is in the $4000.00 range, showing that most of the customers will classify in this range of credit balances. The mean for the credit balance is $3,970.00. The standard deviation is $932.00. The 25% quartile of frequency of customer credit balance is $3,109.00, the median $4,090.00, and the 75% quartile of customers will have $4748.00 in credit balances. C. The 2nd single variable to review is the location of the...

Words: 889 - Pages: 4

Premium Essay

Club It Part Ii

...Our goal at Club IT is to provide a relaxing and safe environment were individuals are able to interact and gather. The client market that Club IT targets is individual between 21 to 30 years old. Since alcoholic beverages are served the age cutoff has to be 21 to meet the law requirments. There have been several changes done at Club IT in last several months. With these new implemented systems Club It will be able to benefit as a whole. With the analysis that was given in Part 1 they can be supplemented in with the new recommendations. The new recommendations will include kiosk, a night sales audit, and a updated sound system. Using the kiosk system will allow the company to facility all entry-level employee’s work. This system will allow the kiosk to input the orders of the customers made by the waiters and bartenders. The orders could include appetizers, drinks, memorabilia items, and tickets. This system will be maintained and joined with paper trail. By having this paper trail will allow for less mistakes to be made and to serve as a reference if the kiosk total doesn’t add up on the night audit. Night audits will be performed by the managers to check the accuracy of the floor employee’s accounting. Merchandise for the customers will be shot glasses, baseball caps, glass mugs, and t-shirts. The night audit system will integrate the transactions for the night of all product combination sales. When a customer purchases something it automatically logs it on the inventory...

Words: 825 - Pages: 4

Premium Essay

Jasmine Powell Case Summary

...children. o Bella & Ruby were adopted by her aunt o Colton, Nathan, Jace are all being taken care of by PGF Charles Weathersbee. • Income: o Bmo: Kimberly Powell reported that she was between jobs. o Charles Harrison-paramour reported that he was working at Harrison’s hardware store in Aiken SC, and does roofing side jobs o When asked how she provides for her children, she replied” I have a strong support system.” • Collaterals o Charles Weathersbee: address: 187 Cobblestone rd. Ridge Spring, SC 29129  706-226-5701-Bmo provided  803-286-6612-listed in report  803-685-6212-diligent search results  803-685-5705-diligent search results o NONE OF THE NUMBERS LISTED ABOVE ARE WORKING NUMBERS FOR CHARLES WEATHERBEE. o Lilly Mae Harrison  803-522-4533 o Physicians that were provided  Release of information forms with signatures stored. • Addressing allegations in report: o Denied selling her children for mobile home and cash o Denied being a prostitute o Bmo reported that she has always had custody of all her children o Denied snatching IV out for no reason. o Bmo reported that she snatched the IV out, because the nurse on duty put her on Lasix. She had to urine really bad, so she jumped up to use the restroom and didn’t make it in time to urine in the toilet. She reported that she did urine some on the floor of the bathroom, and the rest in the toilet. o Bmo and paramour reported that they have NOT been smoking cigarettes in the room. Paramour reported that he normally goes outside...

Words: 824 - Pages: 4

Premium Essay

Applied Managerial Statistics

...Introduction AJ DAVIS is a department store chain, which has many credit customers and wants to find out more information about these customers. A sample of 50 credit customers is selected with data collected on the following five variables: 1. Location (Rural, Urban, Suburban)
 2. Income (in $1,000’s)
 3. Size (Household size)
 4. Years (the number of years that the customer has lived in the current location) 5. Credit balance (the customers current credit balance on the store’s credit card, in $ Dollars) Individual variables a. Location Location | Frequency | Relative Frequency | Rural | 13 | 0.26 | Suburban | 15 | 0.3 | Urban | 22 | 0.44 | n= | 50 | 1 | The table and the pie chart above, show the location of AJ Davis’ customers distributed in 3 areas: rural, suburban and urban. The majority of customers live in urban areas with 44% or 22 out of 50. Suburban areas with 30% or 15 out of 50 of customers are the second and rural areas have the least amount of customers with 26% or 13 out of 50. b. Income Variable Income ($1000) | | | | n=50 | | | | | | | | | | Mean= 43.74 | Std Dev=14.64 | | Q1=30 | Median=42 | | Min=21 | | Q3=55 | Mode=55 | | Max=67 | | Range=46 | Based on the table and histogram, the range of customer’s income is $46,000, with the highest income at $67,000 and the lowest at $21,000. The mean (average) income of a customer is $43,740. The median income is $43,000. Because the median is less than the...

Words: 901 - Pages: 4

Premium Essay

Math533: Applied Managerial Statistics Course Project – Part a

...MATH533: Applied Managerial Statistics Course project – part A I. Introduction. AJ DAVIS is a department store chain, which has many credit customers and wants to find out more information about these customers. A sample of 50 credit customers is selected with data collected on the following five variables: 1. Location (Rural, Urban, Suburban) 2. Income (in $1,000’s) 3. Size (Household size) 4. Years (the number of years that the customer has lived in the current location) 5. Credit balance (the customers current credit balance on the store’s credit card, in $) II. Individual variables. 1. Location Tally for Discrete Variables: Location Location Count Percent Rural 13 26.00 Suburban 15 30.00 Urban 22 44.00 N= 50 [pic] Interpretation: Look at the table and the pie chart above, we can see the location of AJ Davis’ customers is distributed in 3 areas: rural, urban and suburban. The majority of customer live in urban areas with 44%. Suburban areas with 30% of customers are the second and rural areas have the least amount of customers with 26%. 2. Income. Descriptive Statistics: Income ($1000) Total Variable Count Mean StDev Minimum Q1 Median Q3 Maximum Income ($1000) 50 43.74 14.64 21.00 30.00 43.00 55.00 67.00 Variable Range Income ($1000) 46.00 [pic] Interpretation: Based on the table and histogram, we have some comments as follow. The range of customer’s...

Words: 965 - Pages: 4

Premium Essay

Syllabus

...University of LaVerne Point Mugu, California COURSE: Management Information Systems – BUS 410 INSTRUCTOR: Eric Weinstein Phone: (805) 208-4533 E-mail: eweinstein@laverne.edu URL: http://www.ericsoftwaresolutions.com CLASS TIME: Wednesdays 5:00-10:00p.m. (10 sessions) COURSE DESCRIPTION: Provides an end user an overview of information systems viewed from the needs of management. Covers different aspects of system design and implementation including: data processing, collection, storage, updating and retrieval. “Real world” cases will be used to illustrate concepts described in class. COURSE MATERIALS: TEXT: Information Technology for Management. Advancing Sustainable, Profitable Business Growth. Ninth Edition. Efraim Turban, Linda Volonino, Gregory R. Wood. COURSE EVALUATION: Course Grades: This class uses the + / - grading system. The following breakout depicts how grades will be assigned under this system. Please note that final letter grade assignment is subjective. I will not necessarily assign the grade represented by your weighted score. |Grades |Percentage | |A |93 up to 100 | |A- |90 up to 93 | |B+ |87 up to 90 | |B |83 up to 87 | |B- |80 up to 83 ...

Words: 1254 - Pages: 6

Premium Essay

Statistic Analysis

...AJ DAVIS DEPARTMENT STORES Credit Customer Sample Analysis September 16 2013 Created by: Created for: Upper Management TABLE OF CONTENTS Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Income by Location (Bar Graph) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Credit Balances by Income (Histogram) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Credit Balances by Size (Scatterplot) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Credit Balances by Location (Box Plot) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Size Frequency (Dotplot) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Conclusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 INTRODUCTION AJ Davis is a department store chain with many customers who hold credit accounts at the store. The company’s management group wants to analyze the data collected and summarized to determine if there is any connection or relationship between the information...

Words: 1194 - Pages: 5

Premium Essay

Making a Financial Case

...ILM Level 5 Diploma in Management Making a Financial Case Gower College Swansea Student ID: CTT8599 Contents Introduction Page 3 Understanding financial concept used to Page 5 inform management decisions Be able to make a financial case to inform Page 19 a management decision Introduction Business and Partnership Unit The Business and Partnership Unit is client liaison team for of all existing and new partnerships with an ambition to deliver efficiencies and improve services. To evidence transparency of the Councils partnerships by implementing an approved monitoring regime. To provide co-ordination, administration and service delivery role of a number of key functions to both customers and staff within the Department of Culture Tourism Leisure and Sport in the City and County of Swansea. Vision Statement To be a functional section that through monitoring and support ensures that the key partner organisations are fulfilling their obligations in respect of the responsibilities identified with legal agreements. Acting as the partnership hub, the unit aims to ensure that all arrangements and public sector funding remain transparent and that key performance and compliance criteria are monitored and reported. To provide administrative and co-ordination and ensure that key assets in the Sport and Leisure portfolio are managed effectively...

Words: 4755 - Pages: 20

Premium Essay

Marketing

...Carbonated Soft Drinks Executive Summary – UK – June 2011 Carbonated Soft Drinks Executive Summary – UK – June 2011 Jonny Forsyth Senior Drinks Analyst The market has been helped by a number of levers: people are drinking less alcohol meaning that soft drinks as a whole have been gaining in ‘share of throat’; the British climate has improved since 2000 creating a greater demand for refreshing drinks; people have become less concerned about being healthy since the economic downturn; and the product is more competitively priced than all its competitors but for bottled water (which is available for free at home, so hardly a like-forlike comparison). 1 Carbonated Soft Drinks Executive Summary – UK – June 2011 The Market FIGURE 1: MARKET SIZE AND FORECAST FOR VALUE SALES OF CARBONATED SOFT DRINKS, 2006-16 7,000 6,000 5,000 4,000 3,000 2,000 1,000 0 2006 (£m) 4,448 Market value (£m) Best case (£m) 5,929 Mintel forecast (£m) 5,214 Worst case (£m) 4,499 Confidence intervals 95% 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 90% 70% 50% Est. Actual Forecast SOURCE: SYMPHONYIRI GROUP/MINTEL ESTIMATE Since 2006, the carbonated soft drinks market has shown all the signs of being mature, with volume sales remaining constant over this period. The market does, however, remain a huge revenue driver: worth £4.45 billion in 2011. Mintel forecasts that – helped by its value indulgence proposition, strong branding and the increasing popularity of...

Words: 1894 - Pages: 8

Premium Essay

Notes

...I. OVERVIEW/ INTRODUCTION As a tropical country, the Philippines has untapped vast potential of solar energy; yet in 1980’s, solar application is beyond the bound of possible solutions in rural, remote areas in the country. Thus in February 27, 1981, Federal Republic of Germany and Republic of the Philippines entered into a contract to develop applications of solar energy in the Philippines. This project was called the Philippine German Solar Energy Project (PGSEP) which was funded by the German Bundesministeruim for Zussamenarbeit through the Gesselchaft for Zussamenarbeit, and Philippine Office Energy. The governing body of the said project was the Philippine National Oil Corporation through its Energy Research and Development Center. Solar power systems is done through the encapsulation of the solar energy from the sun through the photovoltaic (PV) panels which produce direct current (DC) power to run a DC appliance. Additionally, DC current can be converted alternating current (AC) to run AC appliances. The project was anticipated to solve the inexistence of electrical power resources to provide for the basic needs that immediately improve the lives of Filipinos in areas where electricity is not readily available. II. TIME FRAME The proponents point for analysis would be on 1988. This is based on the data given concerning the commencement of PGSEP (Philippine-German Solar Energy Project) on February 27, 1981 to develop a solar source of energy in the Philippines...

Words: 2885 - Pages: 12

Premium Essay

Child Care Business Plan

...Early Beginnings Child Care Center [pic] Website: WWW.EarlyBeginnings.Com Contact Info: Phone (501)221-4533 Fax (501)221-4534 Email: EarlyBeginnings@edu.gov Table of Contents Executive Summary 3 Company Direction 4 Present Situation 4 Vision and Mission…………………………………………………………….4 Strategic Goals and Objectives 4 Company Overview 5 Product and Service Strategy 5 Current Profile 5 Shifts/Staffing…………………………………………………………………6 Research and Development……………………………………………………6 Service and Delivery…………………………………………………………..7 Market Analysis 7 Market Definition……………………………………………………………...7 Customer Profile 7 Competition 8 Risk…………………………………………………………………………… 8 Marketing Plan 9 Sales Strategy………………………………………………………………….9 Pricing Strategy 9 Advertising and Promotion 9 Financial Plan 10 Assumptions 10 Summary of Financial Statements 10 Capital Requirements 10 Conclusion 11 Supporting Documents 11 Income Statements (2014, 2015) 11 Cash Flow Statements (2014, 2015) 13 Balance Sheets (2014, 2015) 15 Executive Summary Early Beginnings Child Care is a childcare facility that provides child care service in the Little Rock, AR area. This child care facility serves children from 8 weeks to 10 years of age. Unlike our competitor we provide over night service to our consumers. Our services are safe...

Words: 2530 - Pages: 11

Free Essay

Traffic Control Algorithm

...Research on the Method and Simulation of Intersection Signal Control based on Multi-agent Jian Zhang Ling Yan Yin Han Gao Song Xue-li Fang Traffic Engineering Research Institute Business School, University of Shanghai for Science and Technology Shanghai 200093, China E-mail:08zhangjian@gmail.com Abstract—On the basis of analyzing development actualities and trends of urban traffic control system, this paper applied the modeling idea and method of multi-agent, constructed an intersection agent, a section agent and a phase agent for isolated intersection control system based on multi-agent technology, studied their structure, function and each agent’s mission, and discussed the relationship among the three types of agent. By control simulating of three actual intersections, it is indicated that the control effect based on multi-agent is much better than the effect of fix-time. The results indicate that the multi-agent technology is an effective method to improve the effect of the current traffic control system, has research value and application value. Keywords-adaptive traffic signal control system; multi-agent; intersection agent; section agent; phase agent artificial intelligence technology, traffic signal control system is developing gradually in the direction of intelligent direction and integrated direction, the research on Intelligent Urban Traffic Control System based on the distribution-coordination has become a new trend[1,4]. Luckily, the agent technology[2,5,6...

Words: 3284 - Pages: 14

Free Essay

Moive and Culture

...This document is attributed to Jack Lule and Flat World Knowledge 8.2 Movies and Culture LEARNING OBJECTIVES 1. 2. Recognize how movies reflect cultural attitudes, trends, and events. Indicate how movies influence culture. Movies Mirror Culture The relationship between movies and culture involves a complicated dynamic; while American movies certainly influence the mass culture that consumes them, they are also an integral part of that culture, a product of it, and therefore a reflection of prevailing concerns, attitudes, and beliefs. In considering the relationship between film and culture, it is important to keep in mind that, while certain ideologies may be prevalent in a given era, not only is American culture as diverse as the populations that form it, but it is also constantly changing from one period to the next. Mainstream films produced in the late 1940s and into the 1950s, for example, reflected the conservatism that dominated the sociopolitical arenas of the time. However, by the 1960s, a reactionary youth culture began to emerge in opposition to the dominant institutions, and these antiestablishment views soon found their way onto screen—a far cry from the attitudes most commonly represented only a few years earlier. In one sense, movies could be characterized as America’s storytellers. Not only do Hollywood films reflect certain commonly held attitudes and beliefs about what it means to be American, but they also portray contemporary trends, issues, and...

Words: 4070 - Pages: 17

Premium Essay

Consumer Behavior

...[pic] IQRA UNIVERSITY “Comparative analysis of consumer preferences for women clothing brands in Pakistan” Foreign brands Vs Local brand Consumer Behavior Research Project Report Submitted to: Shahnawaz Adil PREPARED BY: Jawaria Vohra 4533 (javeria.vohra@hotmail.com) Komal Sarwar 4172 ( komi.sarwar@hotmail.com) Mehwish fareed 4266 (m4mehwish32@gmail.com ) Huma sohail (humasohail90@gmail.com) Mariam Shahid (mariam-marry@hotmail.com) CHAPTER 1 INTRODUCTION 1. Introduction. The topic is being researched upon because the Pakistani women now play a vital role in the economy of Pakistan and now have a greater buying power and consumption pattern while purchasing clothes. Clothing is one of the most essential factors of one’s daily life, especially when it comes to women. Gone are the days when women used to sit back at home and their husbands used to shop and buy them a dress a month. Contrary to it the contemporary fashion market is being revolutionized and being known by the women clothing industry at its major part 1.2 Background Globalization has lead to a vast information and decision making set for everyone. Due to globalization, people are aware of product, their attributes, quality, prices and the number of substitutes they can refer for a certain product or service. As a result of globalization, a gap between nations and their culture have reduced, and people are adopting the trends of other countries...

Words: 6942 - Pages: 28