Using the data set that you generated in Excel and the Data Analysis Toolpak (see video on adding the Toolpak in the Live Binder), calculate the mean, median, mode, standard deviation, variance, range, minimum, and maximum.

There are two parts to this Discussion. Address both parts in one discussion post.
Part A: What is your experience with Excel? Have you used it before? Do you use it at work or at home? Have you used it to do statistical analyses? If you are proficient with Excel, make sure to provide help to anyone who is having difficulty with the program.

Part B: View this video (https://www.youtube.com/watch?v=EJQHUyWhHmI&feature=youtu.be) to learn how to generate a random data set in Excel. Then using the Unit 1 Discussion Excel workbook, generate your random data set. The data set you create will represent the IQs of a sample of 30 people.

Using the data set that you generated in Excel and the Data Analysis Toolpak (see video on adding the Toolpak in the Live Binder), calculate the mean, median, mode, standard deviation, variance, range, minimum, and maximum. Then answer the following questions:

Insert your descriptive statistics output from Excel within your response (see How to Use A Snipping Tool video in the Live Binder).
What do the following measures of center tell us about the IQs in the data set (be specific and include the values in your discussion – up to 3 decimal places): (i) mean (ii) median (iii) mode?
Does the mean appear to be similar or different from the median? Why do you think that is so?
What is the standard deviation (give the actual value – up to 3 decimal places), and what does it tell us about the IQs in the data set?
How might the information in this data set be useful?
MAKE SURE TO ATTACH YOUR EXCEL FILE TO YOUR POST.
Please create personalized and substantive responses to at least two other student main posts. In your responses, suggestions include the following: What similarities and/or differences do you notice in your sample results and your classmate’s results? Do you think both of your samples most likely came from the same population or different populations, and why?

Remember that your goal for Discussion Assignments is to ensure:

Responses are on topic, original, and contribute to the quality of the Discussion.
Responses make frequent, informed references to unit material.
Responses are clearly written.
A minimum of two or more responses per thread to classmates that are thoughtful and advance the Discussion are required.
Be sure your post is grammatically correct, has been spell checked, and fully answers the question. Be sure to comment on and respond substantively to your classmates’ postings throughout the week (minimum of 2 peer replies).

What is the unstandardized beta coefficient for the education variable as shown on the SPSS printout? Explain what this unstandardized beta coefficient means?

Data analysis in criminal justice:
Input the data from the textbook (page 16) into SPSS.

Run descriptive statistics. What is the mean for the education variable? What is the mean for the income variable?

Run a regression analysis.

What is the coefficient for the intercept as shown on the SPSS printout? What does the coefficient for the intercept mean?

What is the unstandardized beta coefficient for the education variable as shown on the SPSS printout? Explain what this unstandardized beta coefficient means?

Turn in the SPSS printout and your answers to the questions. Keep in mind that your results and answers should mirror what is reported in the textbook.

Code the following variables into SPSS. The first variable is the individual’s sex [M = Male F = Female (Female is the reference category)] and the second variable is the individual’s religion [C = Catholic, P = Protestant, J = Jewish, and M = Muslim (Muslim is the reference category)].

1. M, C 2. M, P 3. M, J 4. M, M 5. M, C 6. F, P 7. F, J 8. F, M 9. F, C 10. F, P 11. M, J 12. M, M 13. M, C 14. M, P 15. M, J 16. F, M 17. F, C 18. F, P 19. F, J 20. F, M 21. M, C 22. M, P 23. M, J 24. M, M 25. M, C 26. F, P 27. F, J 28. F, M 29. F, C 30. F, P 31. M, J 32. M, M

Once the new variables are coded into SPSS, you need to run a regression analysis with the following independent variables: education, sex and religion. The dependent variable is income.
Interpret the unstandardized betas for all the independent variables and the intercept.

Interpret the R2 for the overall model.

What is the adjusted R2 for the model?

What variable has the greatest relative impact among the independent variables (the largest standardized beta coefficient)?

Run a regression equation with education as the independent variable. Then add the sex variable to the equation and check the change in R2. Why are there two changes in R2 reported in the SPSS output? What does the first reported change in R2 mean? What does the second reported change in R2 mean?

Run a regression equation with education as the independent variable. Then add the religion variables to the equation and check the change in R2. Why are there two changes in R2 reported in the SPSS output? What does the first reported change in R2 mean? What does the second reported change in R2 mean?

the whole paper should be consisting of 5 calculations + 1 page ( academic paper writing )

Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Domestic cars. What is the margin of error?

Option #1: Critical Thinking: Cars

An expert who works for a car magazine obtained random data (rounded to the nearest thousand) among two categories of used or new cars: Domestic Foreign

The expert would like to understand sales based on list price (rounded to the nearest thousand dollars), sale price (rounded to the nearest thousand dollars), and number of days it takes to sell each car. The complete data set is in the file named Cars.

Managerial Report

Prepare a report (see below) that summarizes your assessment of the nature of the car market. Be sure to include the following seven items in your report.

  1. Calculate descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Domestic cars.
    • Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier.
    • If a result is an outlier, state whether it is below or above the mean.
    • How can one use the above descriptive statistics to understand the Domestic car market better?
    • Could there be any other descriptive statistics that can help one understand the Domestic car market better?
  2. Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Foreign cars.
    • Use z-scores to determine if there any outliers in the data set for any of the three variables.
    • If there are any outliers in any category, please list them and state for which category they are an outlier.
    • If a result is an outlier, state whether it is below or above the mean.
    • How can one use the above descriptive statistics to understand the Foreign car market better?
    • Could there be any other descriptive statistic that can help one understand the Foreign car market better?
  3. Compare your summary results from #1 and #2. Discuss any specific statistical results that would help the car expert understand the two-car markets.
  4. Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Domestic cars. What is the margin of error?
    • Interpret what each confidence intervals means. How can both confidence intervals provide useful car sales information?
    • What other confidence interval would you choose to compute to obtain more information related to Domestic car sales? Explain why.
    • What happens to the confidence interval as the level of confidence is increased?
  5. Option #1: Critical Thinking: CarsAn expert who works for a car magazine obtained random data (rounded to the nearest thousand) among two categories of used or new cars: Domestic Foreign

    The expert would like to understand sales based on list price (rounded to the nearest thousand dollars), sale price (rounded to the nearest thousand dollars), and number of days it takes to sell each car. The complete data set is in the file named Cars.

    Managerial Report

    Prepare a report (see below) that summarizes your assessment of the nature of the car market. Be sure to include the following seven items in your report.

    1. Calculate descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Domestic cars.
      • Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier.
      • If a result is an outlier, state whether it is below or above the mean.
      • How can one use the above descriptive statistics to understand the Domestic car market better?
      • Could there be any other descriptive statistics that can help one understand the Domestic car market better?
    2. Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Foreign cars.
      • Use z-scores to determine if there any outliers in the data set for any of the three variables.
      • If there are any outliers in any category, please list them and state for which category they are an outlier.
      • If a result is an outlier, state whether it is below or above the mean.
      • How can one use the above descriptive statistics to understand the Foreign car market better?
      • Could there be any other descriptive statistic that can help one understand the Foreign car market better?
    3. Compare your summary results from #1 and #2. Discuss any specific statistical results that would help the car expert understand the two-car markets.
    4. Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Domestic cars. What is the margin of error?
      • Interpret what each confidence intervals means. How can both confidence intervals provide useful car sales information?
      • What other confidence interval would you choose to compute to obtain more information related to Domestic car sales? Explain why.
      • What happens to the confidence interval as the level of confidence is increased?
    5. Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Foreign cars. What is the margin of error?
      • Interpret what each confidence intervals means. How can both confidence intervals provide useful car sales information?
      • What other confidence interval would you choose to compute to obtain more information related to Domestic car sales? Explain why.
    6. Assume the car expert requested estimates of the mean number of days to sell for the Domestic cars with a margin of error of seven days and the mean selling price of foreign cars with a margin of error of eight days.
      • Using 98% confidence, how large should the sample sizes be for each one?
      • How could the sample size formula be useful in understanding both types of car businesses? What are some advantages of a larger sample size?
      • Suppose a Domestic car has a list price of $30,000 and a Foreign car has a list price of $30,000. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these cars?
      • How would these two estimates be useful in this application?

    Write a report that adheres to the formatting and APA expectations outlined on the Citing & APA Resources page (Links to an external site.) in the CSU-Global Writing Center. As with all written assignments at CSU-Global, you should have in-text citations and a reference page.

    Submit your Excel file in addition to your report.

    Requirements:

    1. Paper must be written in third person.
    2. Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library(Links to an external site.) is a great place to find resources.
    3. Include a title page, introduction, body, conclusion, and a reference page.
    4. The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.
    5. The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
    6. The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
    7. Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.
    8. Document formatting, citations, and style should conform to the Citing & APA Resources page(Links to an external site.). A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper (Links to an external site.). In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab (Links to an external site.) has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).

     

    • Interpret what each confidence intervals means. How can both confidence intervals provide useful car sales information?
    • What other confidence interval would you choose to compute to obtain more information related to Domestic car sales? Explain why.
  6. Assume the car expert requested estimates of the mean number of days to sell for the Domestic cars with a margin of error of seven days and the mean selling price of foreign cars with a margin of error of eight days.
    • Using 98% confidence, how large should the sample sizes be for each one?
    • How could the sample size formula be useful in understanding both types of car businesses? What are some advantages of a larger sample size?
    • Suppose a Domestic car has a list price of $30,000 and a Foreign car has a list price of $30,000. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these cars?
    • How would these two estimates be useful in this application?

Write a report that adheres to the formatting and APA expectations outlined on the Citing & APA Resources page (Links to an external site.) in the CSU-Global Writing Center. As with all written assignments at CSU-Global, you should have in-text citations and a reference page.

Submit your Excel file in addition to your report.

Requirements:

  1. Paper must be written in third person.
  2. Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library(Links to an external site.) is a great place to find resources.
  3. Include a title page, introduction, body, conclusion, and a reference page.
  4. The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.
  5. The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
  6. The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
  7. Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.
  8. Document formatting, citations, and style should conform to the Citing & APA Resources page(Links to an external site.). A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper (Links to an external site.). In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab (Links to an external site.) has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).

 

What do these three proportions tell you about customer satisfaction at A1 hotels? What graphical displays of data would you use to understand or explain the results of the survey?

Option #1: Critical Thinking: Quality at A1 Hotels

A1 Hotels operates luxury hotels throughout the world. Recently, motivated by some incidents that appeared in the news, they have been concerned about the quality of service. The company has been giving the following survey to its clients after their stay:

  1. How would you rate the quality of your room? Select one.

Good(G), Poor(P)

  1. How would you rate the quality of your food? Select one.

Good(G), Poor(P)

  1. How would you rate the quality of your service? Select one.

Good (G), Poor(P)

Any customer who answered “Poor” to at least one of the three questions above is considered to be “dissatisfied.” Traditionally, 40% of customers have been dissatisfied.

A1 Hotels would like to see if the recent level of customer satisfaction has changed. Therefore, 200 survey responses were recently chosen at random for analysis. The complete data set is in the file named Hotels.

Managerial Report

Prepare a report (see below) for A1 Hotels that summarizes your assessment of customer satisfaction. Be sure to include the following seven items in your report.

  1. To summarize the data, compute the proportion of all clients that
    1. Answered “Poor” to room quality.
    2. Answered “Poor” to food quality.
    3. Answered “Poor” to service quality.
  2. What do these three proportions tell you about customer satisfaction at A1 hotels? What graphical displays of data would you use to understand or explain the results of the survey?
  3. What is the point estimate of the proportion of all recent clients who were “dissatisfied?” Develop the 92% confidence interval for the proportion of all recent clients who were “dissatisfied.” Interpret what the confidence interval tells you about the proportion of all recent clients who were “dissatisfied.” What is the corresponding margin of error? How can the margin of error be decreased?
  4. Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to room quality. Interpret what the confidence interval tells you about the proportion of all recent clients who answered “Poor” to room quality. What is the corresponding margin of error? How can the margin of error be decreased?
  5. Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to food quality. Interpret what the confidence interval tells you about the proportion of all recent clients who answered “Poor” to food quality. What is the corresponding margin of error? How can the margin of error be decreased?
  6. Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to service quality. Interpret what the confidence interval tells you about the proportion of all recent clients who answered “Poor” to service quality. What is the corresponding margin of error? How can the margin of error be decreased?
  7. Conduct a hypothesis test, using both the p-Value Approach and the Critical Value Approach, to determine if the proportion of all recent clients is more dissatisfied than the traditional level of dissatisfaction. Use α = 0.08 level of significance. Do not forget to include the correctly worded hypothesis and show all of the steps required to conduct the hypothesis test.
    1. What would be possible effects of a lower and then of a higher level of significance?
    2. What other hypothesis tests would you use to better understand hotel customer satisfaction?
    3. What advice would you give A1 Hotels based upon your analysis of the data?
    4. What is the magnitude of the improvement (if any)?
    5. How can this study be improved?

Write a report that adheres to the formatting and APA expectations outlined on the Citing & APA Resources page (Links to an external site.) in the CSU-Global Writing Center. As with all written assignments at CSU-Global, you should have in-text citations and a reference page.

Submit your Excel file in addition to your report.

Requirements:

  1. Paper must be written in third person.
  2. Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library(Links to an external site.) is a great place to find resources.
  3. Include a title page, introduction, body, conclusion, and a reference page.
  4. The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.
  5. The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
  6. The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
  7. Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.
  8. Document formatting, citations, and style should conform to the Citing & APA Resources page(Links to an external site.). A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper (Links to an external site.). In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab (Links to an external site.) has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).

 

Conduct a discounted cash flow analysis in order to select the best project investment.

Managing Your Frozen Pizza Business

Our exercise simulates the types of decisions all managers will make in their planning and controlling functions. Although there are formulas and templates to facilitate the process, ultimately it is the manager’s judgement that interprets the data. Effective decision making often relies on doing the correct analysis in order to support instinct.

In this Course Project, we will complete these interrelated activities.

  1. Develop an operating budget using the contribution margin format.
  2. Prepare a cash budget based on projected cash receipts, disbursements, investing, and financing activities.
  3. Conduct variance analysis between the budget and actual results.
  4. Decide whether or not to outsource production.
  5. Conduct a discounted cash flow analysis in order to select the best project investment.

Background

You own a frozen pizza manufacturing and distribution business. Our premium product, Buzz All Natural Pizza appeals to the adult learners at DeVry University. A marketing survey revealed a time-starved segment that is always in need of energy at the end of the day or week in order to do their schoolwork. Also being poor time managers, this homogenous group requires a more direct form of intervention in order to reach peak academic performance. In order to meet this need, your pizza has caffeinated tomato sauce.

Details and Instructions

Download this Course Project Spreadsheet (Links to an external site.). You are responsible for entering data in each of the spreadsheets (see tabs at the bottom of the file). Each spreadsheet represents a deliverable. Data entry is required in the yellow highlighted cells. After you have input into the prescribed formulas, you are to explain the calculated answers.

There are instructions in each of the five worksheets. The worksheets are submitted in the weeks, as indicated below. This is a summary of the requirements.

Deliverable #1

The Operating Budget (Week 3)

  1. Input the sales volume, as projected by your Field Sales managers.
  2. Input your forecast product mix, as provided by the Marketing department.
  3. Input the efficiency rate for your direct labor, as projected by the VP of Manufacturing.
  4. Input the sales commission, as provided by the VP of Sales and the department’s fixed costs.
  5. Input the administrative fixed costs as provided by the CFO.
  6. Calculate and comment on the break-even point.
  7. Calculate the sales volume needed to reach a target profit and comments.

The Cash Budget (Week 3)

  1. If needed, copy the sales from the first quarter operating budget.
  2. Using an aging of the collection period, as provided by the credit manager, forecast cash receipts by month.
  3. Calculate the cash disbursements by month.
  4. Determine the timing of a capital expenditure.
  5. Determine the timing and amount of financing.

To see details of this assignment, go to the Week 3 Course Project: Deliverable #1 Overview page. Submit your deliverable(s) to the Week 3 Course Project: Deliverable #1 Submission page.

Deliverable #2

Performance Evaluation (Week 5)

  1. Given actual results and the operating budgeted rates, prepare a flexible budget for 1 month.
  2. Explain deviations from plan.

Incremental Analysis: Do We Outsource? (Week 5)

  1. Using the operating budget for the quarter, prepare the relevant costs for in-house production.
  2. Given avoidable costs, calculate whether the outsourcing decision will save costs in total.

To see details of this assignment, go to the Week 5 Course Project: Deliverable #2 Overview page. Submit your deliverable(s) to the Week 5 Course Project: Deliverable #2 Submission page.

Deliverable #3

Course Project Justification (Week 7)

  1. Input the positive cash flows due to production cost savings.
  2. Expenditure for the major maintenance should occur in Year 7.
  3. Using Excel functions, given a hurdle rate, calculate the project’s Net Present Value (=NPV) and the Internal Rate of Return (=IRR).
  4. Calculate the payback period and profitability index.
  5. Provide a recommendation as to whether this project is acceptable.
  6. To see details of this assignment, go to the Week 7 Course Project: Deliverable #3 Overview page. Submit your deliverable(s) to the Week 7 Course Project: Deliverable #3 Submission page.

 

What is the most appropriate numerical measure to describe your data? why did you choose that?

First Design a study to investigate the relationship between smoking and Lung cancer….then answer these questions.

1) Identify your Population.

2) How would you choose your sample—Justify your method

3)How would you collect data?

4) What type of data did you collect? (Note: you don’t have to physically collect the data for this assignment)

5) What will be the most appropriate way to organize and present your data? Why?

6) What is the most appropriate numerical measure to describe your data? why did you choose that?

7) What are your constraints?
Don’t answer the questions in essay form, keep question numbers for the answers.pick a topic based on the study

Determine the current production capacity for each manufacturing line. Determine the monthly utilization rate for each production line.

Determine the capacity of production lines. Ameriwidget’s CEO has asked you to perform a series of small calculations in order to determine the capacity of the production lines used by Ameriwidget. Use the data provided in the “Ameriwidget Data” and “Ameriwidget Info” spreadsheet to make these calculations, and then submit them as part of your logistics analysis. In order to determine the capacity of Ameriwidget’s production lines, do the following:

  • Determine the current production capacity for each manufacturing line.
  • Determine the monthly utilization rate for each production line.

Company background: Ameriwidget is a medium-sized bicycle manufacturer located in Wichita, Kansas. It produces three lines of bicycles: a cruiser, a mountain bike, and a “fixie” city bike. Product lines: At any one time, Ameriwidget is likely in the process of producing three different types of bicycles based on market demand projections and current finished-goods inventory levels. Anticipated demand: Based on historical figures for growth within the company’s product lines, the company anticipates that sales will grow by 7% each month. Production line: To construct a bicycle, the Ameriwidget production line has consolidated and streamlined its production process so that its six different fabrication machines are capable of working 16 machine hours per day, five days a week, producing an average of one bicycle every three hours. As demand is relatively even across its product lines, Ameriwidget has assigned two machines to each production line.

Is there a statistical difference in the scores for saving energy and the importance of owning a computer in your sample?

Level 5 Research Methods – Case Study on Quantitative Data Analysis – Individual Project
Go to the NZ Census at School Website (https://new.censusatschool.org.nz/tools/random-sampler/) and download a 200 person sample of UK students (Random Sampler) from the CAS International database. Each of these will be a random sample so no two samples will have the same data so copying another person’s work will be obvious!!!!
You should complete the tasks below – please read them CAREFULLY (especially the HINTS) and only do what is required – anything extra will be good practice but will not get you any more marks!!!
Data Cleaning and Entry
The data is in .csv format that can be loaded into virtually any analysis package, however it has not been “cleaned”.
Task Output Required for Assessment Marks Assigned Clean the data by removing blank lines or lines with incomplete data, correcting obvious data errors and making sure all data is in the correct format. Enter the data into SPSS, making sure the data is coded correctly and appropriate labels are assigned .sav file or screen dump of both data and variable tabs 10 For each variable (column), generate one or more appropriate summary statistics. Word document 10
Data Display
Data should always be displayed in an appropriate format. To do this you can use any tools you have been given or know about – marks are awarded on the appropriateness of the graphic, its accuracy and information content.
Task Output Required for Assessment Marks Assigned For each of the research questions below, generate an appropriate graphic with an associated paragraph explaining your findings. HINT graphs should be different types for each part What is the age distribution of your sample, and does it differ between the genders? Image in Word File with brief text description 10 Is there a relationship between Height and Arm-Span and does this differ between genders? Image in Word File with brief text description 10 How does the Median and Range of Heights vary with age and does this differ between genders? Image in Word File with text description 20

Statistical Analysis;
Task Output Required for Assessment Marks Assigned For each of the research questions below, run an appropriate statistical test with an associated paragraph explaining your assumptions and findings. HINT there should be different tests for each section Is there a statistical difference in reaction time between genders in your sample?
Is there a statistical difference in the scores for saving energy and the importance of owning a computer in your sample?
Word file with details of the test used, justification of the test (based on YOUR data and findings) and appropriately formatted results of your chosen statistical test 20.
Is there a statistical difference between region of the UK with regard to the importance of reducing pollution, and if there is, where are these differences most apparent?
Word file with details of the test used, justification of the test (based on YOUR data and findings) and appropriately formatted results of your chosen statistical test 20.

Describe a research hypothesis (unrelated to the Food Consumption dataset) that could be assessed using a dependent samples t-test. Be sure to describe your variables.

PSY 510 SPSS Assignment 4

Before you begin the assignment:

  • Review the video tutorial in the Module Eight resources for an overview of comparing means in SPSS.
  • Download and open the Food Consumption SPSS data set.

 

An overview of the data set:

This data set presents the results of a hypothetical experiment that examined dieting, food consumption, and mood. In the first session of the experiment, a sample of dieters and non-dieters were given a plate of food from a popular restaurant. The amount of food (in ounces) that they consumed was measured. In addition, their mood was measured. One week later, the same participants were tested again. This time, while they were eating their plate of food, they also watched a funny movie. Researchers again measured food consumption and mood, as well as participants’ feelings about their body and self-esteem. Specifically, the following variables are included:

  • Subnum: This is the ID number given to track each participant in the experiment.
  • Dietingstatus: This identifies whether or not the participant self-identified as a dieter. If the participant was not dieting, he or she was coded as a “1”, and if the participant was dieting, he or she was coded as a “2”.
  • Consumption1: The amount of food (in ounces) eaten at time 1.
  • Consumption2: The amount of food (in ounces) eaten at time 2.
  • Mood1: Participants’ mood at time 1. Scale ranged from 1 (negative mood) to 10 (positive mood).
  • Mood2: Participants’ mood at time 2. Scale ranged from 1 (negative mood) to 10 (positive mood).
  • Bodyimage: Participants’ self-reported body satisfaction. Scale ranged from 25 (dissatisfied) to 50 (satisfied).
  • Selfesteem: Participants’ self-esteem rating. Scale ranged from 15 (low self-esteem) to 30 (high self-esteem).

 

Questions:

1a) Use the Compare Means function to examine the means for dieters and non-dieters on the Body Image and Self Esteem variables.

Paste relevant output below:

1b) Describe the differences in means that you see.

 

Type your answer below:

2a) Conduct independent samples t-tests to see if the differences noted above are significant. In other words, conduct two independent samples t-tests, one examining the relationship between Dieting Status and Body Image and one examining the relationship between Dieting Status and Self-Esteem.

Paste your relevant output below (Read carefully: The best way to do this is to select “Copy Special” when copying from the SPSS output. Then select image as a format to copy. When pasting in Word, select Paste Special, choose a picture format, and then resize the image so it fits the screen):

2b) Use the Sig. (2-tailed) column to find the p-values for each test. Based on these p-values, are either of the tests significant? How do you know? Based on the significance of the tests, what would you conclude about the relationship between dieting and body image and the relationship between dieting and self-esteem?

 

Type your answer below:

3a) Use SPSS to calculate the means for Consumption1, Consumption2, Mood1, and Mood2.

 

Paste your relevant output below:

3b) From the means, describe how scores on Consumption and Mood changed from Time 1 to Time 2.

 

Type your answer below:

3b) Conduct dependent samples t-tests on the Consumption variables and the Mood variables. In other words, you need to conduct two separate dependent samples t-tests.

 

Paste your relevant output below (use the same copy/paste technique as in 2a):

3c) Use the Sig. (2-tailed) column to find the p-values for each test. Based on these p-values, are either of the tests significant? How do you know? Based on the significance of the tests, what would you conclude about the changes in consumption and mood?

 

Type your answer below:

4a) Describe a research hypothesis (unrelated to the Food Consumption dataset) that could be assessed using a dependent samples t-test. Be sure to describe your variables.

 

Type your answer below: 

4b) Enter hypothetical data relevant to your research question for at least 10 participants. Then, conduct a dependent samples t-test on the data in SPSS.

 

Paste relevant output below:

4c) Describe whether your research question was supported from the hypothetical data. Be sure to incorporate statistical significance into your answer.

Describe ethical issues in business, market and academic research that apply to your proposal.

Objectives/ Learning Outcomes

The coursework assessment is designed to enable you to partially demonstrate the learning outcomes required for the successful completion of the module, with particular reference to the business/market/academic research skills development outcomes for this component as detailed in the module specification and module handbook:

  • Evaluating secondary data sources such as academic literature and market research reports to frame research question
  • Demonstrating understanding of development, conduct, analysis and interpretation of business, market and academic research to propose a research plan
  • Working creatively with qualitative and quantitative (and potentially alternative research methods)
  • Understanding of ethical issues in business, market and academic research that apply to your proposal
  • Producing a succinct, well-argued and well-presented research proposal.

This Research Proposal is mostly based on topics you have covered over your degree programme so far. This gives you a choice of topics to focus upon (see below): a list of potential topic choices is given in this module handbook to help those undecided about what to focus on. Groups are free to choose a topic that is not on the list (as long as it is ethically sound).

You are asked to play the part of a business researcher or market research agency, submitting a proposal document to the client for their approval of your plan to research the question you choose. In order to create an appropriate proposal, you are required to analyse the existing academic and practitioner literature in the area, identify an aim and objectives, develop a strategy for sampling, collecting, analysing and interpreting data, and discuss the ethical and other limitations of your research. The research proposal is to outline a mixed methods (qualitative AND quantitative) research project.

Although practically-focused, this assessment requires an academic slant uniting academic and practitioner knowledge. You are expected to integrate academic concepts and theories from your other modules, and your own reading, to underpin your work and support the judgements you are making. In this regard it is essential that you properly reference all books, academic articles, websites and other reference sources used in your report.

Your Research Proposal is expected to cover the following (N.B. Word counts given here are approximate guidelines only):

  • Introduction briefly covering justification for research (approx. 100 words)
  • A short literature review identifying clear gap in theoretical and practical knowledge (approx. 500 words)
  • Aim and objectives (approx. 75 words)
  • Research methods covering both quantitative and qualitative approaches in a mixed methods study. These approaches should be covered separately (in whichever order you prefer and which makes sense for your study) and in each of the two sections should cover:
    • Clear sampling plan for each stage, including sampling frame, sample size, intended recruitment methods and any requirements for incentives (approx. 200 words e. approximately 100 words on the qualitative and 100 words on the quantitative sampling plan)
    • Outline of data collection methods for each approach, and commentary on how any surveys or moderators guides will be developed. This should include consideration of issues such as socially desirable responding, issues with literacy etc. Details about conducting the research (e.g. environment, recording data, any materials required) should be covered (approx. 400 words for EACH of quantitative and qualitative)
    • Plans for data presentation, coding, analysis and interpretation suitable for each research approach (approx. 200 words for EACH of quantitative and qualitative).
  • Consideration of ethics issues arising from the research and how you would address these (approx. 200 words)
  • Description of any limitations of the research (approx. 100 words)
  • Proposed time frame for the research, ideally using Gantt chart (max. 100 words) and brief closing summary

 

More detail is provided below about content for each section and marking criteria.

 

Formatting

The report should

  • Be in a Microsoft Word format (i.e. a .doc or .docx file) to allow feedback, with 1.5 or double line spacing and 12 sized font.
  • Be submitted online via Blackboard
  • Use headings and subheadings to provide a clear structure
  • Use diagrams, charts or images where they help support your argument
  • Spellcheck your work
  • Use UWE Harvard referencing style (see Library website for details)
  • Anything in the main body of the report beyond this word limit of 2,000-2,500 words runs the risk of not being read or marked. The word count includes everything in (but is not limited to) the main body of the text listed here: abstract, text, headings, tables, citations, quotes, lists, acronyms and numbers expressed as digits or in words. It does NOT include the contents page, the references section or the appendices.
  • Criteria for marking;

We expect cohesive and logical research methods that build on each other to achieve your research aim and objectives. The marking criteria are split between the key sections of the assignment, and reflect the content and quality of each section and the proposal as a whole. See the marking grid below on how this is applied at each grade level, with details on expected content.

Note that the word count guidelines for individual sections are JUST guidelines.

Introduction / Background and literature review: 20%

  • Effective summary of, and introduction to, the research issue (approx. 100 words)
  • Introduction with clear signposting of structure and content of proposal (approx. 100 words)
  • A SHORT Review of key academic literature (8-10 papers) on the research topic, identifying key theoretical constructs and leading to justified aims and objectives (approx. 500 words)

Aims and objectives: 10% (approx. 75 words)

  • Clearly defined overall research aim
  • Objectives suitable for each research approach
  • All answering research brief while using theory from literature review

The following methodology sections MUST link to what you found in your literature review, and achieve your aim and objectives. The qualitative section usually goes before the quantitative section, however as long as you use an integrated mixed methods approach, which you justify, this can be adapted to suit your own plan, but there must a section for each methodology. A brief introduction to how you plan to integrate the two methodologies is advised.

Qualitative methodology: 25%

This section requires:

Clear sampling plan, including sampling frame, sample size, intended recruitment methods/issues with access and any requirements for incentives (approx. 100 words)

Outline of qualitative data collection method(s), and commentary on how these will be carried out to ensure robust data is gathered. This should describe how you would prepare materials such as moderator’s guides (though no actual moderator’s guide is required) and details about conducting the research (where/when/how) (approx. 400 words)

Plans for data presentation, coding, analysis and interpretation suitable for qualitative research (approx. 200 words).

Quantitative methodology: 25%

This section usually goes after the qualitative section and requires:

Clear sampling plan, including sampling frame, sample size, intended recruitment methods/issues with access and any requirements for incentives (approx. 100 words)

Outline of quantitative data collection method(s), and commentary on how these will be carried out to ensure robust data is gathered. This should describe how you would prepare materials such as a questionnaire (though no actual questionnaire is required) and details about conducting the research (where/when/how) to maximize generalizability and reliability (approx. 400 words)

Plans for data presentation, coding, analysis and interpretation suitable for quantitative research (approx. 200 words).

Ethics, Limitations, Timings: 10%

Outline of ethical issues arising through the research and how these would be addressed (approx. 200 words)

Description of any unavoidable limitations of the research that threaten robustness of the study, measures taken to reduce them (approx. 100 words)

Proposed time frame for the research, ideally using Gantt chart (max. 100 words) and brief closing summary.

Overall presentation: 10%

Develop an effective structure for addressing all the tasks.

Maintain a succinct and compelling style throughout.

Clear links between sections to build arguments consistently.

Provide accurate references for all researched or quoted material (including background information on organisations)

Use grammatically correct English without spelling errors.