DATCB/565: Data Diagnosis And Replace Analytics
Competency 1 – Overview
Competency Overview Title: Competency 1 Overview
Total Different of Aspects: 100
Overview Directions
Overview Crucial substances
Scenario:
Pastas R Us, Inc. is a fleet-informal restaurant chain specializing in noodle-essentially based completely dishes, soups, and salads. Since its inception, the enterprise model crew has preferred opening novel restaurants in areas (internal a 3-mile radius) that satisfy the following demographic prerequisites:
- Median age between 25 and forty five years extinct
- Household median earnings above national sensible
- No longer decrease than 15% college-trained adult inhabitants
Final year, the promoting department rolled out a loyalty card approach to develop gross sales. Below this program, customers unique their loyalty card when paying for his or her orders and receive some free food after making 10 purchases.
The company has aloof data from its 74 restaurants to look at well-known variables equivalent to sensible gross sales per buyer, year-on-year gross sales progress, gross sales per sq. ft., loyalty card utilization as a share of gross sales, and others. A key metric of business performance in the restaurant enterprise is annual gross sales per sq. ft. For example, if a 1,200 sq. ft. restaurant recorded $2 million in gross sales closing year, then it sold $1,667 per sq. ft.
Executive management wants to understand whether the unique growth criteria will also be improved; have in thoughts the effectiveness of the loyalty card marketing approach; and title likely, actionable opportunities for enchancment. As a member of the analytics department, you’ve been assigned the accountability of conducting an intensive statistical diagnosis of the corporate’s on hand database to acknowledge to executive management’s questions.
Fragment 1: Descriptive Statistics Diagnosis
Conduct the following descriptive statistics analyses the remark of the PastasR Us, Inc. data living in Microsoft Excel. Reply the questions in the spreadsheet or a separate Microsoft Be aware document.
Insert a novel column in the database that corresponds to AnnualSales. AnnualSales is the consequence of multiplying a cafe’s SqFt by Gross sales/SqFt.
Calculate the following:
- mean
- original deviation
- skew
- 5-quantity summary
- interquartile vary (IQR) for every of the variables
Blueprint a box-living for the AnnualSales variable and acknowledge the following questions:
- Does it contemplate symmetric?
- Would you want the IQR as a substitute of the original deviation to characterize this variable’s dispersion? Why or why no longer?
Blueprint a histogram for the Gross sales/SqFt variable and acknowledge the following questions:
- Is the distribution symmetric? If no longer, what is the skew?
- Are there any outliers? If so, which one(s)?
- What’s the SqFt home of the outlier(s)? Is the outlier(s) smaller or greater than the typical restaurant in the database? What are you able to make from this observation?
- What measure of central tendency is more acceptable to characterize Gross sales/SqFt? Why?
Cite references to support your project.
Continue to Fragment 2: Story.
Fragment 2: Story
Write a 750- to 1,000-observe statistical document with the following sections:
- Part 1: Scope and Descriptive Statistics
- Part 2: Diagnosis
- Part 3: Suggestions and Implementation
Part 1: Scope and Descriptive Statistics
- Inform the document’s arrangement.
- Focus on the nature of the unique database. What variables had been analyzed?
- Summarize your descriptive statistics findings from Fragment 1. Spend a table and insert acceptable graphs.
Part 2: Diagnosis
The remark of Microsoft Excel, receive scatter plots and display the regression equations for the following pairs of variables:
- BachDeg% versus Gross sales/SqFt
- MedIncome versus Gross sales/SqFt
- MedAge versus Gross sales/SqFt
- LoyaltyCard(%) versus SalesGrowth(%)
On your document, embrace the scatter plots. For every scatter living, designate the fashion of relationship noticed (increasing/particular, reducing/negative, or no relationship) and settle what’s going to also be concluded from these relationships.
Part 3: Suggestions and Implementation
- Per your findings above, assess which growth criteria seem to be more functional. Is there any growth criterion that also can very successfully be modified or eliminated? If so, which one and why?
- Per your findings above, does it seem as if the loyalty card is positively correlated with gross sales progress? Would you imply altering this marketing approach?
- Per your outdated findings, imply marketing positioning that targets a particular demographic. (Hint: Are youthful other folks patronizing the restaurants bigger than older other folks?)
- Computer screen what data ought to be aloof to look at and have in thoughts the effectiveness of your suggestions. How can this data be aloof? (Hint: would you remark behold/samples or census data?)
Cite references to support your project.
Resources
- Center for Writing Excellence
- Reference and Quotation Generator
- Grammar Help
Computer screen: Please be particular that that when citing or referencing an out of doors resource or external entity that supreme attribution is made to that source. An instance of a technique for citing out of doors sources will also be level to in the APA seventh edition handbook. Even whenever you happen to is probably going no longer graded on your ability to structure citations in a particular structure, it is anticipated that every person novices submit work that is representative of their very hold original thoughts and work, and clearly attribute when referencing out of doors sources or entities when completing competency assessments.
Assignment / Efficiency Requirements Mastery 100%
1. 1. Fragment 1: “AnnualSales” mean, original deviation, skew, 5-quantity summary, and interquartile vary (IQR) for every of the variables (weight 5%) Accurately inserted novel column in the database titled “AnnualSales” and precisely calculated the final following: the mean, original deviation, skew, 5-quantity summary, and interquartile vary (IQR) for every of the variables
2. 2. Fragment 1: “AnnualSales” box-living (weight 5%) Accurately created a box-living for the “AnnualSales” variable; clearly and precisely answered the final given questions
3. 3. Fragment 1: “Gross sales/SqFt” histogram (weight 5%) Accurately created a histogram for the “Gross sales/SqFt” variable; clearly and precisely answered the final given questions
4. 4. Fragment 1: “Gross sales/SqFt” central tendency (weight 5%) Thoroughly analyzed what measure of central tendency is more acceptable to characterize “Gross sales/SqFt” and clearly outlined why
5. 5. Fragment 2: Scope (weight 10%) Thoroughly said the document’s arrangement and completely discussed the nature of the unique database
6. 6. Fragment 2: Descriptive statistics (weight 10%) Thoroughly summarized descriptive statistics findings the remark of a table and graphs
7. 7. Fragment 2: Scatter plots (weight 10%) Accurately created scatter plots and regression equations for given variables
8. Fragment 2: Diagnosis of scatter plots (weight 10%) Thoroughly designated the fashion of relationship noticed from scatter plots and completely particular what to make from these relationships
9. Fragment 2: Suggestion (weight 20%) Thoroughly assessed which growth criteria seem to be more functional in present to imply marketing positioning that targets a particular demographic
10. Fragment 2: Implementation (weight 20%) Thoroughly outlined what data ought to be aloof to look at and have in thoughts the effectiveness of the suggestions.
Additional Computer screen:
FOLLOW Assignment / Efficiency Requirements Mastery 100%
This wants to pass ZERO GPT and plagiarism assessments.
Want, scholarly references and intext citations.
Excel wanted, observe wanted and so forth
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER
Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.
We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.
Why Choose AcademicWritersBay.com?
- Our papers are 100% original, custom-written from scratch.
- We’re here to support you around the clock, any day of the year.
- You’ll find our prices competitive and reasonable.
- We handle papers across all subjects, regardless of urgency or difficulty.
- Need a paper urgently? We can deliver within 6 hours!
- Relax with our on-time delivery commitment.
- We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
- Benefit from unlimited amendments upon request to get the paper you envisioned.
- We pledge our dedication to meeting your expectations and achieving the grade you deserve.
Our Process: Getting started with us is as simple as can be. Here’s how to do it:
- Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
- Provide the specifics of your paper in the “PAPER DETAILS” section.
- Select your academic level, the deadline, and the required number of pages.
- Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
- Follow the simple payment instructions and soon, our writers will be hard at work on your paper.
AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.
