Your manager is looking for your recommendations for how the store could best respond to: declining sales, reducing staffing, and purchasing the building.To do this, download and fill out the Calculations and Report Document (attached).As you complete part one of this document, break down each of the three problems individually. When representing problems as expressions, don’t be afraid to try a few equations for each step to see what works. Use information and data from the company files in the “Supporting Materials” section to answer the questions.In part two, give your recommendations to your manager: what do you think the company should do about declining sales, reducing staffing, and purchasing the building? Be sure to support your recommendations with quantitative evidence. Then, explain how you used mathematical expressions to solve these problems.When you have completed both parts of the Calculations and Report Document, you can submit it as your deliverable.All materials needed have been attached.

DQ1Reflect on collection of data, data cleansing and preparation activities, and selection and application of models, including challenges/struggles, procedures, approach, etc.How do you know that the data you are collecting will be useful?DQ2When summarizing your data, how did you decide which visualization tool you would use to best communicate this information (bar graph or line graph)?AssignmentNow that you have identified the business problem, translated it into an analytics problem, identified the data needs, and acquired the data, you will use data that you have found or with the company's permission you can use its data for analysis to resolve the analytics problem. Using one or more of the following software applications (IBM SPSS Modeler, SPSS Statistics, Excel, Tableau, or R), analyze the data so that the findings can be used to address the established business problem in your company.Write a 750-1,000 word paper that includes the following information for your data (ensure that specific screenshots of graphs, tables, etc., are provided):Conduct an exploratory data analysis: What information is contained in the data set?Describe key features of the data and any significant relationships you find.How did you verify that the data was reliable before proceeding?What problems did you find and how did you address them?What relationships did you find in the data?Any missing data?Analyze trends with respect to any appropriate characteristics that you may have discovered.Supplement your description with appropriate charts/figures. Data can be (but are not necessarily limited to) the following:Line graphsPie chartsBar chartsScatter plotsIndicate the steps you have taken to investigate the quality of the data and indicate any variables you have transformed or discarded as a result.Provide a summary that provides a detailed overview of the trends identified based upon the analysis.Segment the data accordingly, if needed, to help describe the data behavior.How are you going to summarize data samples?Provide a detailed statistical summary of all information provided.Provide the raw software files that you used for this assignment. If R was used, provide a *.txt file of all the commands used.Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.