Lincolnville School District Bus Data Assignment
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Lincolnville School District Bus Data Assignment
Complete the problems below from the textbook. You will need to use the “Lincolnville School District Bus Data” and the “Century National Bank Data” files for this assignment.
- Chapter 3 – Problem 88
- Chapter 4 – Problem 25
- Chapter 4 – Problem 46
- Chapter 5 – Problem 94
- Chapter 4 Case A – Century National Bank
For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.
Submit output in one Excel file.
- Refer to the Lincolnville School District bus data. Prepare a report on the maintenance cost for last month. Be sure to answer the following questions in your report.
- Around what values do the data tend to cluster? Specifically, what was the mean maintenance cost last month? What is the median cost? Is one measure more representative of the typical cost than the others?
- What is the range of maintenance costs? What is the standard deviation? About 95% of the maintenance costs are between what two values?
- The Director of Planning for Devine Dining Inc. wishes to study the relationship between the gender of a guest and whether the guest orders dessert. To investigate the relationship, the manager collected the following information on 200 recent customers.
- What is the level of measurement of the two variables?
- What is the above table called?
- Does the evidence in the table suggest men are more likely to order dessert than women? Explain why.
- Refer to the Lincolnville School District bus data.
- Referring to the maintenance cost variable, develop a box plot. What are the mini-mum, first quartile, median, third quartile, and maximum values? Are there any outliers?
- Using the median maintenance cost, develop a contingency table with bus manufacturer as one variable and whether the maintenance cost was above or below the median as the other variable. What are your conclusions?
- Refer to the Lincolnville school bus data. Set up a variable that divides the age of the buses into three groups: new (less than 5 years old), medium (5 but less than 10 years), and old (10 or more years). The median maintenance cost is $4,179. Based on this value, create a variable for those less than or equal to the median (low maintenance) and those more than the median (high maintenance cost). Finally, develop a table to show the relationship between maintenance cost and age of the bus.
- What percentage of the buses are less than five years old?
- What percentage of the buses less than five years old have low maintenance costs?
- What percentage of the buses ten or more years old have high maintenance costs?
- Does maintenance cost seem to be related to the age of the bus? Hint: Compare the maintenance cost of the old buses with the cost of the new buses? Would you conclude maintenance cost is independent of the age?
- Century National Bank
The following case will appear in subsequent review sections. Assume that you work in the Planning Department of the Century National Bank and report to Ms. Lamberg. You will need to do some data analysis and prepare a short writ-ten report. Remember, Mr. Selig is the president of the bank, so you will want to ensure that your report is complete and accurate. A copy of the data appears in Appendix A.6. Century National Bank has offices in several cities in the Midwest and the southeastern part of the United States. Mr. Dan Selig, president and CEO, would like to know the characteristics of his checking account customers.
What is the balance of a typical customer?
How many other bank services do the checking ac-count customers use?
Do the customers use the ATM ser-vice and, if so, how often?
What about debit cards?
Who uses them, and how often are they used?
To better understand the customers, Mr. Selig asked Ms. Wendy Lamberg, director of planning, to select a sample of customers and prepare a report. To begin, she has appointed a team from her staff. You are the head of the team and responsible for preparing the report. You select a random sample of 60 customers.
In addition to the balance in each account at the end of last month, you determine (1) the number of ATM (automatic teller machine) transactions in the last month; (2) the number of other bank ser-vices (a savings account, a certificate of deposit, etc.) the customer uses; (3) whether the customer has a debit card (this is a bank service in which charges are made directly to the customer’s account); and (4) whether or not interest is paid on the checking account. The sample includes customers from the branches in Cincinnati, Ohio; Atlanta, Georgia; Louisville, Kentucky; and Erie, Pennsylvania.
- Develop a graph or table that portrays the checking balances. What is the balance of a typical customer? Do many customers have more than $2,000 in their accounts? Does it appear that there is a difference in the distribution of the accounts among the four branches? Around what value do the account balances tend to cluster?
- Determine the mean and median of the checking ac-count balances. Compare the mean and the median balances for the four branches. Is there a difference among the branches? Be sure to explain the difference between the mean and the median in your report.
- Determine the range and the standard deviation of the checking account balances. What do the first and third quartiles show? Determine the coefficient of skewness and indicate what it shows. Because Mr. Selig does not deal with statistics daily, include a brief description and interpretation of the standard deviation and other measures.
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Lincolnville School District Bus Data Assignment