Final Project Milestone Three: Statistical Analysis Report

  • Introduction to the Problem

Description of the Scenario. The scenario presents an organization operating in the gift cards industry. The sale of the gift cards to the people is essential to create joy. The delivery of gifts and cards across states in the U.S. is affected by a number of features which determine the number sales and quantity of gifts sold over a certain duration. The gifts covering wedding gifts, appreciation, thanks giving, congratulatory, condolences, among others are a key part of life to comfort and support our loved ones. The organization’s history can be analyzed to include its capacity to sell a specific number of gift cards over a certain period. For example, during Christmas, the sale of gift cards is often high due to the high demand for appreciation and thanks giving. The period over Easter, Valentines Day, Mothers’ Day, Fathers’ Day, among others attracts high number of sales of the gift cards across different varieties. Thus, indicate the high number of factors and seasons prompting high number of sales of the gift cards.

The number of gift cards analyzed in the potentially maximum and minimum amount affect the revenue generation by the company. For the organization to attain the highest revenue possible, the maximum amount of gift cards must be sold. This is critical for the overall operations of the company and sustainability of its business. The capacity to sell the maximum number of gift cards is essential to ascertain that the company generates sufficient cash flow, net profit, and gross product essential for the growth and expansion of the company. Therefore, the statistical analysis report examines different statistical tools and methods critical to solve the problem presented by the gift card shop in making critical decisions that ascertain the company great benefits. Thus, provides data driven decisions that are vital for the functionality, operations, and sustainability of the company in the gift cards industry in the United States.

Consequently, the analysis shows a profound need to maintain a high number of sales to ensure that the organization generates sufficient profits for its sustenance. The competitiveness of the organization is determined by its potential to sell the maximum amount of gift cards possible over a specified duration. This is critical to ascertain profits generations and future continuity of the business enterprise. The analysis plan below evaluates a number of key aspects and statistical analysis that inform decision making. The decision making for the company is based in extensive analysis of data to inform decisions based on factual performance of the company in the industry. Thus, enhance its competitiveness and productivity in the long-term.

  • Analysis Plan

Calculation of the Central Tendency of the Dependent Variable. This comprises of the central tendency of the Gift Amount which is the dependent variable. The Quantity of Gift Amount is fundamental for enhanced performance and competitiveness of the organization in the industry. The calculations find the Central Tendency of the Gift Amount to have a Mean of 15.716623, Median of 14, and Mode of 10 as analyzed in Table 1 below.

Table 1: Summary Statistics of the Central Tendency of the Gift Amount.

Column Mean Median Mode
GIFTAMNT 15.716623 14 10

(Source: Author).

Histogram of the Gift Amount

Figure 1: Histogram of the Gift Amount.

 

(Source: Author).

 

 

 

Scatterplots for the Gift Amount for each Independent Variable

Figure 2: Scatter Plot: Age

(Source: Author).

 

 

 

 

 

Figure 3: Scatter Plot: Children

(Source: Author).

 

 

 

 

 

 

Figure 4: Scatter Plot: Fed Gov.

(Source: Author).

 

 

 

 

 

 

Figure 5: Scatter Plot: State Gov.

(Source: Author).

 

 

 

 

 

 

Figure 6: Scatter Plot: Local Gov.

(Source: Author).

 

 

 

 

 

 

 

Figure 7: Scatter Plot: Home Owner

 

 

 

 

 

 

 

 

(Source: Author).

  • Quantifiable Factors that May Affect Operational Performance

The quantifiable factors that may affect the operational performance of the organization comprises of the independent variables identified above. The independent variables influence the quantity of gift amounts leading to the maximum and minimum results. The data shows that; the favorable conditions of the independent variables enable the organization to make more sales. For instance, from the Scatter Plot Figure 2, ages between 25 – 80 shows a high demand for the gift cards. This results in the increase in the number of gift amounts generated over the period. The young children at “0” are more prevalent than the rest affecting the number of gift amounts sold over the specified duration (Figure 3). Also, the Federal (Figure 4), State (Figure 5), and Local Governments (Figure 6) affect the number of the gift amounts to a number of stringent measures introduced by the respective governments affecting the business environment. The home ownership determines the need to purchase of not to purchase the gift cards (Figure 7).

  • Problem Statement

The problem statement identifies the independent variables as critical factors that influence the demand of gift cards in areas of operations by the organization. The capacity to maintain the maximum number of the gift amounts is affected by the respective entity through its various measures they install. The demand among children and different ages influence the number of gift amounts that the organization can potentially sell over a certain period. Thus, for the organization to attain high performance – the factors must be adequately addressed.

  • Strategy for Resolving the Company’s Problem

The capacity to increase productivity and performance of the organization in attaining the set objectives can be attained through proper mitigation measures on the independent variables. That is, among the children, the solution to resolving the problem lies on creating gift cards that entice them and impact on demand increase. On dealing with the age factor – the development of the gift cards should be maintained across the age brackets of the target market. For example, gift cards that target primarily ages 0 – 3, ages 4 – 15, ages 16 – 30, 31 – 59, and 60 – 80. This is bound to increase the number of sales across different categories of the gift cards demands. Finally, the compliance with the Federal, State, and Local governments regulations is crucial to ensure that the legal and political landscape does not affect the operations of the organization adversely. Thus, to ascertain competitiveness and high performance – the governments should work cooperatively to provide a conducive environment for the business operations.

  • Statistical Methods
    • Appropriate Statistical Methods Used to Perform the Analysis.

The appropriate statistical method used in the analysis of the gift cards sales in the case entails the utilization of regression analysis. The regression analysis is used to mathematically sort out the variables that influence the others. That is, the evaluation of the factors that induce the influence of one or more independent variables on a dependent variable (Eratti & Sahin, 2020). In this case, the dependent variable comprises of the gift amount that relies on seven core independent variables that influence the number and quantity of sales by the gift cards shop. The independent variables that profoundly influence the performance of the dependent variable (gift amount) include the age distribution determining the number of sales made across different age groups.

Second, children as they love gifts and different gift cards. A show of appreciation and value for their various achievements at the early age. Third, the Federal government that determines the laws and regulations of business operations across the country. The Federal government is integral to determine interstate operations of the gift cards. This is fundamental to protect the operations and activities of the gift cards across the nation (Kumari & Yadav, 2018). Fourth, the State government responsible for intra-state operations and functionalities. The State government plays a critical role in determining the laws and regulations within the state. Fifth, the Local government that intensifies operations at the local level. The local government is responsible for making the gift cards shop operations more efficient and make the business environment at the grassroots more favorable. For example, in the cities, the municipal government partnership with the gift cards shop can increase the number of sales as they partner to create more awareness on different subjects. Thus, make sales more frequent and enhance the popularity of the gift cards as a culture among the residents.

Sixth, the homeowners are a key variable critical to influence the gift amount variable. Despite being used as a dummy variable, the home owners impact the increase of the gift amount through demand of decorations and the sales of houses. This is essential to impact the gift amount positively. Finally, the veterans (vets) including male, Vietnam and World War II (WWII) vets profoundly influence the gift amount variable. The increase in appreciation and celebration of life well lived by the vets of different categories increases the demand of gift cards. Hence, lead to increase the number of gift cards sales in the United States.

  • Justification of the Methods Selected.

Figure 8 below shows a regression analysis of the influencing variables that affect the overall performance of the gift cards shop. The figure shows a regression analysis of randomly selected variables that illustrate the performance of the company (Huang et al., 2017). The regression analysis illustrates a determination of the performance of the gift card shop. An increase in demand across different categories of independent variables leads to increase the number of sales of gift cards. Therefore, the approach is justifiable to illustrate the impacts of different independent variables requires an increase in demand of all other variables.

 

 

Figure 8: Regression Analysis – Influence Regression.

(Source: Author).

Figure 9 shows the regression analysis of the age variable which comprises of 3,648 samples. The age factor shows high prevalence and desire for the gift amount up to 50. The influence of the age variable on the gift amount is high between ages 20-65. This comprises of the young people (Generation X), Baby Boomers, and the Older people in the sixties. At this point, the need for life appreciation is profound and integral to the sales of the gift cards shop. Thus, the age factor should be address based on the age groups as the target segmentation analyzed earlier in the paper.

Figure 9: Influence in Regression Analysis – Age Variable.

(Source: Author).

Figure 10: Influence in Regression Analysis – Children Variable.

(Source: Author).

 

 

 

Figure 11: Influence in Regression Analysis – FEDGOV Variable.

(Source: Author).

 

 

 

Figure 12: Influence in Regression Analysis – STATEGOV Variable.

(Source: Author).

 

 

 

Figure 13: Influence in Regression Analysis – LOCALGOV Variable.

(Source: Author).

 

 

 

 

Figure 14: Influence in Regression Analysis – VIETVETS Variable.

(Source: Author).

Figures 10, 11, 12, 13, and 14 shows the regression analysis of children, Federal, State, and Local governments, as well as, Vietvets indicates high demand of gift cards. The capacity to maintain high performance and competitiveness of the gift cards shop – the consideration of the variables outlined in the regression analysis is critical for high performance (Arayesh, 2015). Thus, each variable (independent) must be sufficiently address to induce competitive performance of the gift cards shop sales.

  • Data-Driven Decisions
    • Process Needed to Utilize Statistical Analysis Used to Reach a Decisions Regarding the Given Problem.

The statistical analysis tools employed in finding effective solution to the gift cards shop problem comprises the use of regression analysis – influence feature, histogram, and scatterplots. The regression analysis indicates the prevalence of demand of the gift cards on the specific variable in which to pay extensive focus on to increase the number of sales (Huang, Wismeijer, Shao & Wu, 2016). The histogram shows the prevalence in demand of the gift cards leading to increased gift amount sales. The scatterplots show the high demand in the target segmentation. Thus, the use of different tools has been employed to analyze the data critical for decision making.

  • How Data Mining is Used to Develop a Solution to the Case.

Data mining was executed using StatCrunch software to manipulate the raw data from 26 variables and identify seven core variables that are critical in the performance of the gift cards shop. The StatCrunch data mining provides different tools that are fundamental to understand the impact of different variables on the performance of the dependent variable. Thus, lead to competitiveness of the gift cards shop.

  • Structured or Unstructured Problem.

The case problem presented in the scenario comprises of a structured problem that allows the owner to step back, evaluate and analyze the problems affecting the business performance (Kim, Choi, Sung & Park, 2018). As structured problem, the use of statistical analysis tools has been utilized to provide different solutions that can be effective in enhancing the performance of the company (Pee, 2019). In turn, impact on building competitiveness and performance of the gift cards shop in the United States. Thus, the structured problem is addressed through providing viable solutions that can apply to different contexts.

  • Assessment of How the Variables Have Potential for Answering the Problem.

The consideration of each variable critically leads to improved performance and competitiveness of the gift cards shop in the market. For example, the analysis of the age variables presents different sub-groups of the age sets that create the target segmentation of the target audience. The target segmentation enables the creation of the perfect products that precisely fit the target group leading to increased sales. This has a high potential of offering viable solutions to the low sales of the gift card sales. Thus, increase in the gift amount can be enhanced by extensively analyzing the target segments within a particular variable.

  • Recommended Operational Improvement to Stakeholders
    • Data-Driven Calculations that Addresses the Problem Statement.

The data driven calculations show high emphasis should be focused on the following key variables inclusion age, children, federal government, state government, local government, home owners, and the veterans. Data from each variable shows a high need of addressing the demand aspect and the relationship between the company and the consumers. Thus, customer satisfaction and compliance with government regulations and standards of customer experience. Thus, impact in the increase demand of the gift cards.

  • Summary of the Results of the Analysis Plan.

The summary shows that it is fundamental to focus on key variables that profoundly impact on the performance of the gift cards shops. The children and ages between 25-80 showing high demand for the gift cards. In turn, the increase of the gift amount is affected by the high demand influenced by the target audience and the conduciveness of the business environment. The business environment is regulated by the Federal, State, and Local governments impacting on the operations, competitiveness, and performance of the gift cards shop. Thus, high productivity and competitiveness is sustained with the jurisdiction of the United States and respective states have a mandate to play to increase the performance of the gift cards shop.

  • Explanation of How the Model Addresses the Problem Statement.

The model is designed in a way that; the data manipulation is done to identify the variables with the most effect. This is crucial to finding a solution for the operations and functionality of the gift cards shop. The use of continuous marketing strategies on the respective factor. Thus, cumulatively impact on increased performance and competitiveness of the gift cards.

  • References

Arayesh, M. B. (2015). Regression Analysis of Effective Factors on Increasing Factors on Trainer’s Motivation of the Red Crescent Society (A Case Study, Ilam, Iran). Procedia-Social and Behavioral Sciences205, 536-541.

Eratlı Şirin, Y., & Şahin, M. (2020). Investigation of Factors Affecting the Achievement of University Students with Logistic Regression Analysis: School of Physical Education and Sport Example. SAGE Open10(1), 2158244020902082.

Huang, H., Wismeijer, D., Shao, X., & Wu, G. (2016). Mathematical evaluation of the influence of multiple factors on implant stability quotient values in clinical practice: a retrospective study. Therapeutics and clinical risk management12, 1525.

Huang, H., Xu, Z., Shao, X., Wismeijer, D., Sun, P., Wang, J., & Wu, G. (2017). Multivariate linear regression analysis to identify general factors for quantitative predictions of implant stability quotient values. PloS one12(10).

Kim, J. Y., Choi, D. S., Sung, C. S., & Park, J. Y. (2018). The role of problem solving ability on innovative behavior and opportunity recognition in university students. Journal of Open Innovation: Technology, Market, and Complexity4(1), 4.

Kumari, K., & Yadav, S. (2018). Linear regression analysis study. Journal of the Practice of Cardiovascular Sciences4(1), 33.

Pee, L. G. (2019). Enhancing the learning effectiveness of ill-structured problem solving with online co-creation. Studies in Higher Education, 1-15.

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Us

Outstanding Academic Writing Service

At MyMasterPapers.com, you are assured of professional essay writing help from the leading experts online. Quality comes at the forefront of our custom writing service to ensure that all our customers are satisfied with the work delivered. We value repeat customers. For this reason, we ensure that each task is completed to perfection for high scores.

Top Writers

Our hiring process is highly intensive. The writers are exposed to a strict selection procedure before hiring to ensure that we acquire the most qualified, well-educated and experienced writers. Our team of writers, professors, editors and researchers will ensure that you get incredible results.

Plagiarism-Free Papers

We highly discourage plagiarism. For this reason, we have trained our writers in such a way that all the papers are written from scratch and are free from plagiarism. We also pay attention to ensure that each paper is completed as per the instructions provided. Referencing and citations are done as per the paper format selected by the customer. These include: APA, MLA, Chicago, Harvard, Turabian among others.

24/7 Customer Support

You can contact our support team via the chat window at the bottom right corner. Alternatively, feel free to email us via our support email: support@mymasterpapers.com. Our team is available 24/7 to respond to your queries and guide you though where need be.

Swift Delivery & 100% Money Back Guarantee

Simply choose the desired deadline when placing the order. The task is assigned to the most qualified writer as soon as the order is successfully placed. All the papers are delivered to you within the deadline selected. In case a paper cannot be delivered within the deadline selected, we request for a deadline extension within the shortest time possible.

Free Unlimited Revisions

Our customers can always request for a revision in case they feel that something needs to be added or changed after the final paper has been delivered. We do not charge for revisions. However, we highly discourage our customers from misusing this policy.

Try it now!

Calculate the price of your order

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

Mymasterpapers.com specializes in custom essay writing for all level of students. Simply relax as we get your paper done within the timeline indicated.

Essays

Academic Help Service

Our team of skilled writers and researchers is readily available to get any type of academic paper completed. We deliver high quality papers and projects to our customers to ensure that we maintain a long-term relationship that will shine your academic career.

Admissions

Admission Essays & Professional Writing

An admission essay allows you to express yourself by providing personal details that wouldn’t have fit on other areas of an application. We have a team of experienced writers who will get you to the desired academic level through a professional and a personalized admission essay.

Reviews

Editing & proofreading

Are you seeking for editing or proofreading help? We have a team of editors who will ensure that any issue within you paper has been addressed. Upload the paper to be cleaned up and relax as we get the job done.

Reviews

Revision Support

At mymasterpapers.com, you can always ask for revision in case you want some changes in you paper. We focus on ensuring that the grammar, research and formatting are done as per the latest academic writing standards.