Statistics Analysis

Resource: 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?

Sample Solution

remain loyal and will always be interested in the latest products that are available. Using the participants from a program like love island to promote products is a clever idea because they know that the fame will be quick and the attention will come all at once for a short period of time, meaning a lot of people will see the brand quickly.

Pretty Little Thing as they are constantly using influencers and bloggers to promote and wear their clothes, as they know that their audience is young and fashion forward. This also means that they are constantly bringing out clothes that are very much on trend and ‘the in thing’ to wear. Another tactic used by these online brands is to give these influencers discount codes for their audiences as a way of enticing people to shop on their website. “Social media is an incredible tool at the fashion industry’s disposal for marketing. By leveraging social media brands can take control of public perception which is one among the many important factors in fashion marketing.” (Recklies, 2006). By having the control over the marketing process, brands can pick and choose who they want to promote the products and think about who will appeal most to a target audience. By doing this the brand are also able to control opinion and perception meaning that by showing the best parts of the brand and its products it will mean that more people will want to not only purchase the products but also support the brand. Some may say that the industry is manipulative and encourages conspicuous consumption by doing this.

Pretty Little Thing promotes several different influencers and bloggers on their Instagram. A reoccurring face would be the ever-growing fashion influencer, Emily Shak. She has a platform where she shows off her never-ending amount of clothes and her desirable style. Emily Shak has been kn

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.