Assignment ContentResource: Pastas R Us, Inc. Database Review the Wk 2 - Apply: Statistical Report assignment. In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel®. Answer the questions below in your Excel sheet or in a separate Word document:Insert a new column in the database that corresponds to “Annual Sales.” Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.”Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.Create a box-plot for the “Annual Sales” variable. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why?Create a histogram for the “Sales/SqFt” variable. Is the distribution symmetric? If not, what is the skew? Are there any outliers? If so, which one(s)? What is the “SqFt” area of the outlier(s)? Is the outlier(s) smaller or larger than the average restaurant in the database? What can you conclude from this observation?What measure of central tendency is more appropriate to describe “Sales/SqFt”? Why?

Follow directions Statistics play an important role in global management. With SPSS, comparison of means analyses can be conducted, and thus assess performance and/or productivity.General Requirements: Use the following information to ensure successful completion of the assignment:Doctoral learners are required to use APA style for their writing assignments. The APA Style Guide is located in the Student Success Center.You are not required to submit this assignment to LopesWrite.Directions:View "SPSS for Beginners 6a: One-sample t-tests and Confidence Intervals."Open SPSS and complete the following:Obtain an output with a one-sample t-test (as in the tutorial, with the values as seen below).Highlight the level of significance and the confidence intervals.Upload the output into LoudCloud.Data Set:IQ Scores: 102, 110, 110, 110, 100, 105, 101, 104, 107, 101.Instructions SPSS (Statistical Program for the Social Sciences) is a computer program that is the de-facto standard used by research institutions and universities for the completion of quantitative analysis. As a doctoral learner, knowledge of quantitative research techniques and the application of these methods as provided in the application software is a required doctoral competency. Doctoral learners are required to use SPSS during several courses to complete specific assignments. Doctoral learners may execute SPSS Base Module and Advanced Statistics in one of two ways. SPSS Installation on Learner's PC or MACSPSS Base and Advanced Statistics Modules may be installed on a PC or MAC computer. The combined program is very large so please make sure you have at least 2 GB of available disk space on your computer. Once the program file is downloaded, you may access SPSS software to complete classroom assignments and perform quantitative analysis as related to your own research. Actual installation can be performed in less than five minutes after the file has been downloaded. However, the initial download may exceed 60 minutesif your Internet connection is relatively slow. In some instances when the download exceeds 60 minutes, the download may not complete. Should you experience issues when attempting to download the SPSS file, please access the SPSS Server (below). Please use the following links to obtain installation instructions and the program file: Instructions: How to install SPSS on your PCPC Download File – 32 bitPC Download File – 64 bitInstructions: How to install SPSS on your MACMAC Download FileInstructions: How to access the SPSS ServerAll SPSS programs installed on learner computers employ a security activation key which is in effect for 12 months. Should you receive a message indicating your SPSS software is out of date or requires a new activation key, simply follow the PC Updateor MAC Updateinstructions. The update is typically completed in less than five minutes.SPSS Server AccessThe SPSS Server provides a convenient alternative method to access SPSS Base and Advanced Statistics Program via the Internet. Instead of downloading the entire SPSS program onto your computer (which can exceed 60 minutes), you may access the SPSS program via the Internet by downloading a small activation file (in less than five minutes). Once the activation file is downloaded, you may access SPSS software from any location where you are connected to the Internet to complete classroom assignments and perform quantitative analysis as related to your own research. Please use the following link to obtain instructions on how access the SPSS Server. Remember that when completing course assignments using the SPSS server, it is necessary to first download the SPSS data file (.SAV) prior to accessing the SPSS Server. Once the data file is download to your computer, you can OPEN the file directly from SPSS.