Excel assignment due in 36 hours

In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel®. Answer the questions about the information in your Excel sheet 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.” – See reference material below.
· 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.
· Create a histogram for the “Sales/SqFt” variable.

In a separate APA style Word document Answer the following questions based on the results of your analysis in Excel®. As an APA style document remember to have an introduction, the body, and a conclusion. Those should all be based on this analysis from the Pastas R Us, Inc. Database.
· Based box-plot for the “Annual Sales” variable; does the boxplot look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why?
· Based on the 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?

Reference Material:
Scenario:
Pastas R Us, Inc. is a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. Since its inception, the business development team has favored opening new restaurants in areas (within a 3-mile radius) that satisfy the following demographic conditions:
· Median age between 25 – 45 years old
· Household median income above national average
· At least 15% college educated adult population

Last year, the marketing department rolled out a Loyalty Card strategy to increase sales. Under this program, customers present their Loyalty Card when paying for their orders and receive some free food after making 10 purchases.

The company has collected data from its 74 restaurants to track important variables such as average sales per customer, year-on-year sales growth, sales per sq. ft., Loyalty Card usage as a percentage of sales, and others. A key metric of financial performance in the restaurant industry is annual sales per sq. ft. For example, if a 1200 sq. ft. restaurant recorded $2 million in sales last year, then it sold $1,667 per sq. ft.

Top Quality and Well-Researched Papers

We ensure that all instructions are followed meticulously to deliver exactly what you need. You can select your academic level— high school, college/university, or professional— and we will match you with a writer who holds the relevant degree for your task.

Professional and Experienced Academic Writers

Our team of professional writers brings extensive experience in both academic and business writing. Many of our writers are native speakers, ensuring high-quality work for any task you need assistance with.

Free Unlimited Revisions

If you feel something is missing, don’t worry—send your order for a free revision! You have 10 days to request a review after receiving your final document. Simply log into your personal account or contact our support team to initiate the revision process. We’re committed to ensuring your complete satisfaction!

Prompt Delivery and 100% Money-Back-Guarantee

We are committed to delivering all papers on time. Should we require additional time to ensure your paper meets the highest standards, we will reach out to discuss a deadline extension. If an extension is not possible, we offer a 100% refund guarantee to ensure your satisfaction.

Original & Confidential

We utilize advanced writing tools to ensure that every document you receive is free from plagiarism and AI-generated content. Our expert editors meticulously review all citations and references within the text for accuracy. Additionally, we guarantee the highest level of confidentiality with all of our services, ensuring your privacy is always protected.

24/7 Customer Support

Our support agents are available 24/7, dedicated to providing you with the best customer experience. Feel free to reach out anytime you need assistance—we’re here to help!

Try it now!

Calculate the price of your order

Type of paper needed:

Pages:

Academic level:

Total price:

$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Choose peace of mind. Choose Superior Custom Writers—your trusted partner for stress-free academic success!

Essays

Essay Writing Service

No matter the type of academic paper you need or how urgent the deadline, we’ve got you covered! Choose your academic level and paper type, all at an affordable price. Our dedicated team handles all your paper needs while providing round-the-clock, 24/7 customer support for a seamless experience.

Admissions

Admission Essays Help

An admission essay is a critical component of your application, serving as a personal statement highlighting your unique qualities and aspirations for college, university, or graduate school. Our professional writing service,crafts an exceptional, compelling, and tailored admission essay that showcases your strengths and leaves a lasting impression. Let us help you stand out and secure your spot at your dream institution!

Reviews

Editing Support

Our team of expert academic writers and editors ensures your paper is thoroughly polished. We meticulously revise and refine your work, ensuring clarity and coherence. Additionally, we format your document according to your preferred style, including accurate citations and reference lists in APA, Harvard, MLA, Chicago, or Turabian formats.

Reviews

Revision Support

If you feel your paper could be improved, simply request a review. We will have the writer or an editor review your paper to ensure it meets your expectations. You can use this option as many times as needed, at no additional cost, because your satisfaction is our priority. We’re committed to delivering the best possible service, every time.