Purpose 

This assignment is intended to help you learn how to apply statistical methods when analyzing operational data, evaluating the performance of current marketing strategies, and recommending actionable business decisions. This is an opportunity to build critical-thinking and problem-solving skills within the context of data analysis and interpretation. Youll gain a first-hand understanding of how data analytics supports decision-making and adds value to an organization.

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.

Executive management wants to know whether the current expansion criteria can be improved. They want to evaluate the effectiveness of the Loyalty Card marketing strategy and identify feasible, actionable opportunities for improvement. As a member of the analytics department, youve been assigned the responsibility of conducting a thorough statistical analysis of the companys available database to answer executive managements questions.

Report: 

Write a 750-word statistical report that includes the following sections:

• Section 1: Scope and descriptive statistics
• Section 2: Analysis
• Section 3: Recommendations and Implementation

Section 1 – Scope and descriptive statistics

• State the reports objective.
• Discuss the nature of the current database. What variables were analyzed?
• Summarize your descriptive statistics findings from Excel. Use a table and insert appropriate graphs.

Section 2 – Analysis 

• Using Excel, create scatter plots and display the regression equations for the following pairs of variables:
• BachDeg% versus Sales/SqFt
• MedIncome versus Sales/SqFt
• MedAge versus Sales/SqFt
• LoyaltyCard(%) versus SalesGrowth(%)
• In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed (increasing/positive, decreasing/negative, or no relationship) and determine what you can conclude from these relationships.

Section 3: Recommendations and implementation

• Based on your findings above, assess which expansion criteria seem to be more effective.Could any expansion criterion be changed or eliminated? If so, which one and why?
• Based on your findings above, does it appear as if the Loyalty Card is positively correlated with sales growth? Would you recommend changing this marketing strategy?
• Based on your previous findings, recommend marketing positioning that targets a specific demographic. (Hint: Are younger people patronizing the restaurants more than older people?)
• Indicate what information should be collected to track and evaluate the effectiveness of your recommendations. How can this data be collected? (Hint: Would you use survey/samples or census?)

Cite references to support your assignment.

Format your citations according to APA guidelines.

In this module, you explore the normal distribution. A standard normal distribution has a mean of zero and standard deviation of one. The z-score statistic converts a non-standard normal distribution into a standard normal distribution allowing us to use Table A-2 in your textbook and report associated probabilities.

This discussion combines means, standard deviation, z-score, and probability. You are encouraged to complete the textbook reading and start the MyStatLab Homework before starting this discussion.

Scenario

The following table reports simulated annual flying squadron costs (in millions of dollars) at the following locations:

Complete

Use Microsoft Excel and StatDisk to complete the Flying Squadron Costs table for the aircraft type listed below:

• Complete the costs using the B-52 data; use the Kadena data point in your z-score and probability calculations.

Report your values to two decimal places (i.e., 0.12) except for probability. Report probability values to four decimal places (i.e. p = 0.1234).

Your StatDisk results should look similar to this image:

Post & Discuss

Post the images of your spreadsheet and StatDisk results in the discussion area along with a narrative of your findings and the responses to the questions below.

1. Do these costs appear to come from a population that has a normal distribution? Why or why not?
2. Can the mean of your data sample be treated as a value from a population having a normal distribution? Why or why not?
3. Did an unusually low or unusually high z-score value occur?
4. Was the associated z score probability value less than 0.05 (p < 0.05); meaning a significantly low or significantly high event? If yes, what are the implications for the base and/or aircraft?
5. What were your findings? Hint: focus on the calculated mean, standard deviation and z-score (include probability) to interpret your results.

ANCOVA Analysis

A recent study of student anxiety suggested that test anxiety interfered with the effects of studying skills on student test performance. Students were classified as high or low in test anxiety based on responses to an anxiety inventory, then classified as high or low in study skills based on responses to a study skill scale. An overall measure of test performance was obtained by averaging the number of scores of three tests the students completed over the course of a semester. Enter the following data into SPSS and use anANCOVA to analyze the results.

Test Anxiety

Low

High

Studying Skills

Low

6

5

6

3

6

4

5

6

3

2

3

4

3

5

4

1

High

3

4

4

3

3

2

4

5

8

9

9

7

8

9

7

9

1. State the independent variables (factors) and dependent variable in this study.  2. What are the mean test performance scores for each group?  3. State the null and alternative hypotheses for the ANCOVA.  4. State the numerical results for the ANCOVA (include F, df, p, and 2) and state the statistical decision.  5. Write a paragraph as in a journal article that summarizes and interprets the results of the ANCOVA for this study on student test performance. 

MANOVA Analysis

Researchers are interested in the effects of cognitive behavior therapy and behavior therapy on Obsessive Compulsive Disorder. We could compare a group of OCD sufferers after CBT and after behavior therapy with a group of OCD sufferers who are still awaiting treatment (a no treatment condition). 

As OCD has both cognitive and behavioral elements, it is not enough to look only at therapy’s influence on behavioral outcomes. Therefore, our study used two dependent measures: the occurrence of obsession-related behaviors (Actions) and the occurrence of obsession-related cognitions (Thoughts). 

The dependent variables were measured on a single day and so represent the number of obsession-related behaviors/thoughts in a normal day. Use data set OCD.sav.

1. What is/are our research question(s)?

2. Prescreen the data. a. Does our data meet all the assumptions for a MANOVA? 

b. Does the data need to be corrected for outliers and normality? (Copy and paste in to this section the information that helped you reach your conclusion).

c. Does the data demonstrate homogeneity of variance-covariance? (Copy and paste in to this section the information that helped you reach your conclusion).

3. “Run” the MANOVA analysis (i.e., use the printout of SPSS output). a. Which MANOVA test statistic should you use? Why?

4. Using the appropriate group multivariate statistics and ANOVA/post hoc tests, report your results. 

Create a high standard metric showing the below. Show all pivot table fields and metrics/charts used in separate tabs if needed. .

How many total for each Creator ?

For each Creator how many have DEFAULT DOCUMENT TITLE in Title field out of the total they have done.

For each Creator how many have blank/null  in Comments (b2Comments) field out of the total they have done

Translate the Creator id”field into a real name. Creator ID and corresponding name can be found in second tab.  Maybe write a query that will pull the name from the second tab(creator name), just incase i add new Creator ID. So the metric should show Creator name instead of ID.

In the future , I will want to do the same thing multiple times by just copy and paste details into the excel sheet with headings remaining the same.  Therefore, I am looking for a repeatable way to do this so all i have to do is paste new data and i can spit out or refresh  the metric quickly.

Excel file will be attached

 

Refer to Major Assignment 3 attachments (Major Assignment 3, Major Assignment 3 Details, and Country List).

Research the country using The World Factbook found on the Central Intelligence Agency website at  , other resources such as the U.S. Department of State website at  , and the GCU Library.

Include three or more scholarly resources, including the textbook and The World Factbook. 

Use the Country List to help you complete Major Assignment 3.

Prepare this assignment according to the guidelines found in the GCU Style Guides and Templates, 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.

You are required to submit this assignment to LopesWrite. Refer to the for assistance.

Attachments

 

I am looking to publish a paper in this journal: Journal of Taibah University for Science The link of the journal is: https://www.tandfonline.com/tusc20  

please let me know if you can help in writing an article on any topic in Operations research area such as (linear programming, Transportation problem, or assignment Problem,…) just 6- 8 pages _ single space.

My target is to publish a paper in the above journal. So I need an original article research to be accepted.

Please if you are a specialist in this field and you are sure that you can help? please contact me and send me a brief or an abstract about the specific topic that you are planning to write? with your offer.

Best. 

 

The data that you collect from your norm group is called normative data. It allows you to see what the results of your test instrument should be, so that you have a standardized score against which to compare others. In other words, it allows you to equate scores across different tests of the same construct and lets you compare individuals to each other. Now that you have considered sampling the population of interest for your proposed test instrument, you explore how you might optimally define your sample and collect your data if you had unlimited resources. Though it may not always be possible for practical reasons to do this in real life, this exercise nevertheless provides you with a valuable thought experiment.

As you complete this experiment, keep in mind that even with optimal sample definition and data collection, test norms are not absolute. They can change with time or with a different norm group.

With these thoughts in mind:

Post by Day 4 a description of the information you anticipate collecting through your proposed Final Project instrument. Then explain how you would optimally define your sample and collect your data if you had unlimited resources. Finally, explain advantages and disadvantages of your chosen data collection method. Support your response using the Learning Resources and the current literature.

Be sure to support your postings and responses with specific references to the Learning Resources.