# Project #59899 - Data Analysis w/Sprdsh w/Lab

You are an analyst for the Vanguard Mortgage Company has been using a spreadsheet created by you in the past which functions well. The current worksheet you created currently contains the customer’s account, the cost of the house, down payment, amount financed, mortgage rate, loan years (e.g. 30 year), % financed, date financed and payoff year. You have been tasked with enhancing the worksheet to include noted basic summary statistics. Which sorts of summary statistical methods would you include in the updated workbook? Describe at least six statistical measures that you would use so that you could explain them to your supervisor. .

ã€€

4. (TCO 5) Mark Jacobs, owner of Jacob's Mini-Mart currently operates two stores in Atlanta. His business has been very successful, and he is now opening two new stores. He will no longer be able to manage all stores himself, so he is hiring managers for three of the four stores. He will continue to operate one store, and act as general manager over the company. He is looking for an easy and efficient way to collect information from the stores, and he would like your help with the following: PART 1 Marc wants you to design a worksheet for his managers to complete showing the sales by product category by month at each store. He wants to be sure the managers don't change the formulas in the worksheet. Describes the characteristics of the worksheet. PART 2 Describe the process Mark will use in combining the completed worksheets into on workbook and creating the summary report. (Points : 40)

5. You are assigned to analyze a large dataset containing the detailed records of invoices of a company's customers which contain the customer ID, their address, city, region, post code, country and sales person and additional information about specific order id, order date, shipped date, shipper, product ordered, unit price, quantity, discount, ship address, ship city, ship postal code, ship country, and product category name. Explain how you would use Excel and Excel formulas to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations. (Points : 40

 Subject General Due By (Pacific Time) 02/27/2015 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews