Statistical Report: Pastas R Us

Statistical Report: Pastas R Us

Section 1: Scope and Descriptive Statistics

This statistical report aims to determine whether the current expansion criteria for Pastas R Us can be improved. The current company has a loyalty card marketing strategy, and they want to evaluate its effectiveness, feasibility, and growth opportunities. The statistical report will conduct necessary analyses to determine whether these aspects are as expected by the company. The current dataset for the company consists of nine variables, including the Annual Sales, which were determined later. In the current case, the statistical analysis is based on the Past R Us database, including the mean, standard deviation, IQR, summary, and skew for each variable. The software used for data analysis is SPSS, which is recommended for analyzing company data (Ramansh et al., 2020). The other variables in the database include Sales per Person, Square Feet, Median Income, Bachelor’s Degree, Annual Sales, Loyalty Card, and Sales/sq ft. Each of these variables has the same size: n = 74. The key variables analyzed in this case include sales/sq. ft, sales growth, median age, bachelor’s degree, loyalty card, and annual sales.

The scatter plots, as well as regression analysis of different variables, including the combination of the variables, were completed. The outcomes of the analysis reveal that a Bachelor’s Degree significantly affects Sales/sq ft. The analysis also revealed that Medium Income did not impact the Sales/SqFt. At the same time, Loyalty Card appears to be affecting the growth of Sales over the years outlined in the scatter plots as well as regression equations detailed below. Additionally, the standard deviation, skew, mean, summary, and IQR for each variable were determined using the SPSS software. The results are tabulated as shown below.

Descriptive Statistics
	N	Range	Minimum	Maximum	Mean		Std. Deviation	Variance	Skewness
	Statistic	Statistic	Statistic	Statistic	Statistic	Std. Error	Statistic	Statistic	Statistic	Std. Error
Obs	74	73	1	74	37.50	2.500	21.506	462.500	.000	.279
SqFt	74	2548	1251	3799	2580.47	43.583	374.919	140564.280	.527	.279
Sales/Person	74	1.5	6.5	8.0	7.046	.0347	.2985	.089	.956	.279
SalesGrowth%	74	37.1200	-8.3100	28.8100	7.414054	.7701093	6.6247303	43.887	.494	.279
LoyaltyCard%	74	3.1	.3	3.4	2.028	.0642	.5526	.305	-.758	.279
Sales/SqFt	74	809	179	987	420.31	15.954	137.240	18834.687	1.236	.279
MedIncome	74	81424	32929	114353	62807.70	2081.329	17904.273	320562990.020	.298	.279
MedAge	74	18.8	24.7	43.5	35.201	.4248	3.6546	13.356	-.167	.279
BachDeg%	74	26	14	40	26.31	.814	7.005	49.066	.141	.279
Annual Sales (T)	0
Valid N (listwise)	0

Section 2: Analysis

Scatter Plots

“BachDeg%” versus “Sales/SqFt”

The scatter plot above reveals a positive relationship between sales per square foot (Sales/sq ft) and bachelor’s degree. However, the relationship is weak, indicating a fragile positive between the variables.

Y(Sales/SqFt) = 244.035 + 6.7 (BachDeg%)

“MedIncome” versus “Sales/SqFt”

The scatter plot above reveals no relationship between MedIncome and Sales per Square Foot.

Y(Sales/SqFt) = 431.109 + 0 (Med Income)

“MedAge” versus “Sales/SqFt”

The scatter plot indicates a positive relationship. The plot shows a strong positive relationship between Sales/SqFt and MedAge.

“LoyaltyCard(%)” versus “SalesGrowth(%)”

The scatter plot reveals a negative relationship between LoyaltyCard% and Sales Growth. However, the graph shows that the relationship between the two variables is weak.

Y (Sales Growth) = 14.628 – 3.56 (Loyalty Card %)

Section 3: Recommendations and Implementation

Based on the findings from the analysis conducted as well as the plots presented, it is evident that a Bachelor’s Degree has a significantly positive effect on Sales per Square Foot. Medium Income appears not to affect the Sales per Square Foot, while the Loyalty Card percentage seems to be affecting the growth of sales at the organization. Therefore, based on these findings, the expansion criteria seem to be more appropriate for the Bachelor’s Degree, which has been identified to impact sales positively. The expansion criteria that need to be reviewed is the Loyalty Card. The Loyalty Card seems to hurt the sales of Pastas R Us. Since the findings reveal that a negative correlation exists between Loyalty Cards and sales growth, I would recommend that Pasta R Us change its marketing strategy and, if possible, eradicate it completely and replace it with a new one.

The analysis findings also reveal that median age has a negative correlation with Sales per Square Foot. However, the median age positively impacts the company’s annual sales. The Sales per Square Foot are more concentrated on the median youth age, indicating that the youth patronize the restaurant more often than older individuals. As a result, this would be considered the primary target of the business. Most businesses often target young people as their primary target markets (Montez de Oca et al., 2016). The recommendation to Pastas R Us, in this case, would be to maintain the current target market. The essential information that should be collected to aid in tracking the effectiveness of the recommendations, as well as current strategies, includes the total sales made after a specified period.

In addition, the presence of unique or new visitors to the business would be an indicator of whether the proposed recommendations were effective. An increase in the number of clicks from visitors to the company’s website might also indicate that the recommendations and the current marketing strategies are working. There are several ways through which the business could collect information regarding its customers. These include the use of Google Analytics, which can help monitor activities on the company’s website (Gaur et al., 2016). Nevertheless, the company should maintain its current target market and change the Loyalty Card program.

References

Gaur, L., Singh, G., Jeyta, & Kumar, S. (2016). Google Analytics: A Tool to make websites more robust. Proceedings of the Second International Conference on Information and Communication Technology for Competitive Strategies – ICTCS ’16. https://doi.org/10.1145/2905055.2905251

Montez de Oca, J., Meyer, B., & Scholes, J. (2016). Reaching the kids: NFL youth marketing and media. Popular Communication, 14(1), 3–11. https://doi.org/10.1080/15405702.2015.1084623

Ramansh, K., Kalra, P., & Mehrotra, D. (2020). Trend Analysis for Retail Chain Using Statistical Analysis System. Advances in Intelligent Systems and Computing, 53–62. https://doi.org/10.1007/978-981-15-0751-9_5

ORDER A PLAGIARISM-FREE PAPER HERE

We’ll write everything from scratch

---

Assessment Description
Training and development prompts change within an organization. The goal of training is to identify areas for improvement and to develop growth opportunities that support the employees in their professional career.

For this assignment, you are required to develop a small training exercise in the form of a PowerPoint presentation. Review previous needs assessments and training observations conducted at your workplace to help identify one area for improvement that would benefit your organization. This training exercise does not need to be implemented but should include at least one deliverable that you could use during the training exercise. As you are reviewing your organization, consider employee engagement, systems and procedures, communication, resources, succession planning, and the culture within the organization. These are suggestions for possible areas that could benefit from a training exercise.

Create an 8-10 slide PowerPoint presentation of your training exercise, with speaker notes, and include the following:

What are the overall goals for the training or the benefit to the selected organization?
What are two specific objectives for the training exercise?
What processes or procedures will change after the training has been completed?
Describe the strategies or actions involved in the training exercise to meet the established goals and objectives. What is the expected employee performance or application after the training? How will the strategies drive successful business results and improve employee performance?
How will the organization provide support to the current employees receiving this training? To new employees? How will the effectiveness of the training exercise be measured to confirm the anticipated improvement of employee performance?
While APA style format is not required for the body of this assignment, solid academic writing is expected, and in-text citations and references should be presented using documentation guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.