Clayton State University Excel Variables Classification Question

For this Assignment, You are required to

• Classify each of the variables. Hint: Go back to the Notes about Quantitative and Qualitative variables.Be specific. (Quantitative, Qualitative, nominal, categorical, continuous, discrete, ratio, interval etc).
• Create a histogram for each of the numerical variables.Remember to label all axes and title each histogram. Are the histograms symmetrical or skewed? ?EXPLAIN and DISCUSS your results.
• Find the mean, median, and mode for each of the numerical variables.For each of the numerical variables, which is the most appropriate measure of central tendency? Why?EXPLAIN and DISCUSS your results.
• Look at the numerical variables, are there any outliers? EXPLAIN.
• Analyze each day. Use the techniques you have learned from this class.Be clear and detailed.Clearly label your results.Clearly explain your observations.
• Analyzeeach 1 hour period (9-10am, 10-11am, 11am-noon, noon-1pm, 1pm-2pm, 2pm-3pm, 3pm-4pm, and 4pm-5pm). Use the techniques you have learned from this class.Be clear and detailed.Clearly label your results.Clearly explain your observations.
• Based on your results from a.) -g.)
  • What are your observations about the traffic patterns at the bank?
  • Why do you think the bank is experiencing long lines?
  • What are your suggestions to help the bank improve operational efficiency and reduce the long lines?

undefined

Deliverables:

undefined

• Create one spreadsheet for each part. Clearly label the spreadsheets, Part a.), Part b.), Part c.) etc.So, you should have 7 spreadsheets that correspond to parts a.), b.), c.), d.), e.), f.) and g.). Create one more spreadsheet for your miscellaneous work…label it misc work.
• Use boxes, clearly highlight and label your answers. YOUR ORGANIZATION MATTERS.I SHOULD BE ABLE TO CLEARLY FOLLOW YOUR WORK.
• Submit ONE Excel file containing your 8 spreadsheets. I should be able to click on a cell and CLEARLY see the formulas you’ve used.
• Save your MS Excel file as Final5000(insert first letter of your first name, insert lastname).So, I would save my Excel file as Final5000CLaws.
• Remember to label all graphs, tables, charts etc.
• Remember to label each worksheet/tab.
• Remember to clearly label EACH of your answers.