...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
...MATH-533 Applied Managerial Statistics Course Project Part A Introduction It is so interesting to choose sections location, an income and size as representative of my course project. From the list, it really makes me an interest of trend of people who is living in urban, has how many of family members and how much they earn. Basically I would like to categorize the direction of cluster of people and their desires to live which area of country. First, I am going to analyze the locations versus family size, and then family size versus to income. Then I will analyze further how many of family and location has how much income which helps us to reveal to pay back the credits. 1st Individual Variable (Location) Table 1 and graph 1 Location | Number of houses | Rural | 14 | Suburban | 15 | Urban | 21 | From the table 1 and graph 1 shows the number of houses and number of locations. Based on the information customers from AJ Davis tend to live in the Urban area rather than the suburban and rural area. 2nd individual variable (Size) Size (family members) | number of objects | 1 | 5 | 2 | 15 | 3 | 8 | 4 | 9 | 5 | 5 | 6 | 5 | 7 | 3 | Graph 2 and table 2 Based on table 2 information following data comes out. (Numbers of customers) Minimum: 3 Median:5 Q3:8.5 Maximum:15 Based on the graph 2 and table 2, most of the customers intend to have less than 5 family members. The majority of customers have 2 family members and only 3 of them...
Words: 354 - Pages: 2
...Listed you will find data retrieved from AJ DAVIS department store. It includes data from five variables. I will discuss three individual variables and three pairing. The 1st individual variable I will discuss is Location: Frequency Distribution: Location Frequency Urban 1 22 Rural 2 13 Suburban3 15 The pie chart and frequency distribution indicates that majority of AJ DAVIS credit customer resided in the urban area, at 44%. However, the rural and suburban area accounts for over a quarter of the credit holders. This shows that although the major of credit customer resident in urban areas, it is important to cater to the rural and suburban customer as well. This will maintain current credit customers and can increase the number of credit customers in the store chain. The 2nd individual variable I will discuss is Income: Descriptive Statistics Mean 43.74 SD 14.63963 Variance 214.3188 As shown in the descriptive statistics, the mean income is 43.73,000 for credit customers. Credit holders for AJ DAVIS income range from 20,000 to 69,000. The highest frequency of income is 30,000-39,000. The 3rd individual variable I will discuss is Size: Descriptive Statistics Mean 3.42 Median 3 Mode 2 Mean household size for credit customers is 3.42. The highest frequency in household size is 2. This indicates that AJ DAVIS credit customer may shop for multiple people at their visits to the department...
Words: 400 - Pages: 2
...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
...MATH533 Given: 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 – be careful with this) 3. SIZE (Household Size, meaning number of people living in the household) 4. YEARS (the number of years that the customer has lived in the current location) 5. CREDIT BALANCE (the customers current credit card balance on the store's credit card, in $). Each variable was individually considered. Location: A categorical variable, with 3 subcategories, which are; Urban, Suburban and Rural. The frequency distribution and Bar chart are given as follows: Frequency Distribution: | | Location | Frequency | | Urban | 22 | | Suburban | 15 | | Rural | 13 | | | | | From the frequency distribution and bar chart, it is clear that the maximum number of customers belongs to the urban sub-category (44%), followed by those in the suburban sub-category (30%). Only 26% of the customers belong to the rural sub-category. The next variable considered is Size. It is a quantitative variable. The measures of central tendency, variation and other descriptive statistics have been calculated for this variable and are shown below: Frequency Table | Value | Frequency | Frequency % | 1 | 8 | 16.00 | 2 | 7 | 14.00...
Words: 639 - Pages: 3
...Course Project: AJ Davis Department Stores Natasha Unaphum MATH533: Applied Managerial Statistics September 10th, 2014 Professor Rolston Introduction: AJ Davis is a department store chain, they are trying to get to know more about their clientele and to further expand their business. A sample of 50 credit customers are selected for this research, information that includes, location (rural, urban or suburban), Income (in $1,000), size (household size), years (number of years lived in that location), and credit balance (customers current credit card balance on the store’s credit card). Discuss your 1st variable, using graphical, numerical summary and interpretation Numerical Summary of Credit Balance are as follows: Mean: 3970.5 Minimum: 1864 Standard Deviation: 931.9 Q1: 3109.3 Variance: 868429.8 Median: 4090 Skew: -0.15043 Q3: 4747.5 N: 50 Max: 5678 The histogram above shows the Credit Balance variable of the 50 customers surveyed. The histogram is almost symmetrical with one outlier which is the credit balance of $2,000. While it being symmetrical you can almost fold the y-axis in half to have it look the same. While observing the histogram, its skewed to the left because of the outlier, and the skew is -.015043. Using the Anderson-Darling Normality Test, the P-value for Credit Balance is 0.400, and A^2 is 0.38. Throughout...
Words: 866 - Pages: 4
...Maurice S. Butler Math533—Applied Managerial Statistics Course Project: Part A Introduction This project is based upon statistical data compiled concerning AJ Davis Department Stores, specific to a sample of its customer base. It is with intent of establishing relationship between location, gross income, and credit balances carried by customers that the following statistical analysis has been performed. It is assumed that information obtained as well as the interpretation of statistical analysis will enable credible recommendations in regard to future revenues or continued handling and/or maintenance of its receivables. Variables The first variable is the gross income of the stores’ customers. The data set includes 50 customers with gross income ranging from $20,000 to $79,000 per year. Compilation of the data into a frequency/relative frequency table (see below) reveals that the greatest frequency and relative frequency of the store’s customers is found within the $30,000 to $49,000 range. Fifty-two percent of the store’s customer base gross income is found within this range. First and third quartiles have been calculated to be 33 and 57 respectfully. However, no outliers have been identified within the data set. Income ($1000) | Frequency | Relative Frequency | 20-29 | 5 | 10% | 30-39 | 13 | 26% | 40-49 | 13 | 26% | 50-59 | 8 | 16% | 60-69 | 9 | 18% | 70-79 | 2 | 4% | | 50 | 100% | My second variable is the outstanding credit balances of...
Words: 1184 - Pages: 5
