Ramirez Guzman-Week 2-Summative Assessment-Predictive and Qualitative Analysis Report

.docx

School

University of Phoenix *

*We aren’t endorsed by this school

Course

565

Subject

Business

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by SargentTeam8460

SUMMATIVE ASSESSMENT: PREDICTIVE AND QUALITATIVE ANALYSIS REPORT 1 Summative Assessment: Predictive and Qualitative Analysis Report Marisela Ramirez Guzman DAT/565: Data Analysis and Business Analytics (6A) University of Phoenix Professor: Dr. Mohammed Miah November 27 th , 2023

SUMMATIVE ASSESSMENT: PREDICTIVE AND QUALITATIVE ANALYSIS REPORT 2 Predictive and Qualitative Analysis Report Section I - Scope and Descriptive Statistics The Pastas R Us business development team had the opportunity to open new restaurants that were able to meet demographic conditions within a 3-mile radius including: Median age that is between 25-45 years old, meaning that customers would most likely spend time eating on a restaurant setting. Another factor that was considered was the Household median income that is above the national average, which for these restaurants is very favorable because most likely, the community would be able to spend money on a restaurant. And the last demographic factor that was considered was that at least 15% of the adult population is college educated, which can develop the love and appreciation for quality food in the restaurant industry. Last year, our marketing department developed a loyalty card program in which customers present this loyalty card that enables the opportunity of receiving free food after 10 purchases. Objective The organization has been assessing the results of the program and has been collecting data from 74 restaurants to identify how sales are improving. The objective of this statistical report is to analyze the loyalty card program of Pastas R Us to develop recommendations for further advancement and expansion. Nature of current Data and Variables To analyze how business is doing, the research has collected historical financial performance data from 74 restaurants with the purpose of forecasting future financial performance. The data measured areas such as the sales per square foot (Sales/Sq. Ft), sales growth, the median income and age range of customers, loyalty program card consumption, and the number of customers with an educational background with a bachelor's degree.

SUMMATIVE ASSESSMENT: PREDICTIVE AND QUALITATIVE ANALYSIS REPORT 3 Descriptive Statistical Findings After analyzing data and obtaining a descriptive statistical report, the data showed that the organization’s customer median age is about 35, with an income that is around $63,000. This analysis shows that each customer spends around $7. The median annual sales per square foot is about 332.85 with a percentage of 27% approximately, corresponding to college graduate customers. SECTION II – ANALYSIS The Data from Figure 1, we can identify the sales per square foot vs. the percentage of customers with a graduate degree. After analyzing the scatter plot data, it is identified that the results reflect a weak, positive correlation between variables. Also, the regression formula indicates that sales per square foot are related to the percentage of college graduate customers. 10 15 20 25 30 35 40 45 0.00 200.00 400.00 600.00 800.00 1,000.00 1,200.00 f(x) = 6.7 x + 244.03 R² = 0.12 Sales/SqFt vs. College Graduates Bach. Degrees (%) Sales/Sq.Ft. ($) Figure1: Sales/Square Foot vs. College Graduates In Figure 2, reflects the median age of customers in relation to the annual sales per square foot. In this figure, we can identify that the regression equation shows the median income of customers and the sales per square foot have been maintained without many changes.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version