Prepare an analysis of the data using excel

Assignment Help Applied Statistics
Reference no: EM131658564

Project Assignment - Complete this project assignment in which you analyze data from a survey you develop.

Develop a five question survey for researching the creation of a new healthy snack food. Note the overall research question.

Ask five people your survey questions.

Prepare an analysis of the data using Excel. You may create any pivot tables or cross tabulate any information you think is appropriate. Your data compilation must include at least one ANOVA or regression analysis or any other quantitative analysis appropriate for the assignment (feel free to include more than one).

Submit the data tables and charts that you have created. Feel free to use any of the Excel functions to construct the information.

Note any problems found with the data.

An analysis of the data is not required this week; that is part of next week's activities.

This assignment will be scored on the following criteria:

  • Compile data for analysis.
  • Complete a data compilation or regression analysis.
  • Analyze data to identify and address problems.
  • Prepare a data set for analysis.

Reference no: EM131658564

Questions Cloud

What laws are there protecting tenants in your state : Do you think the law does enough to protect tenants from landlords? What laws are there protecting tenants in your state?
Define abdominal distension and pain with palpation : hysical examination reveals a quiet and tired child with normal exam except for increased bowel sounds, but no abdominal distension, pain with palpation
How does this illustrate degrees of freedom : A sample of 10 numbers that has a mean of 8.6. How does this illustrate degrees of freedom?
Discuss the conditions that lead to the freedom with fences : Discuss the conditions that lead to the "freedom with fences" (the ability to be innovative and creative within certain prescribed boundaries) organization.
Prepare an analysis of the data using excel : Prepare an analysis of the data using Excel. You may create any pivot tables or cross tabulate any information you think is appropriate
School-age child sustains two injuries during the year : Find the probability of a school-age child sustains two injuries during the year.
Does lisa have a defense : Lisa and Danny are neighbors that live on Guerrero Street. Does Lisa have a defense? Assume that state in question has adverse possession period of ten years.
How did the dissent interpret the issue before the court : We granted certiorari in this case to determine whether a patent licensee in good standing must breach its license prior to challenging the validity.
Selected the distribution used to solve problem : Assume there are, on the average, 3 random intermittent interruptions in a network service per week.

Reviews

Write a Review

Applied Statistics Questions & Answers

  Company''s prices compare with your competitors

Assume that you work for a chain of food stores and that you are interested in how your company's prices compare with your competitors. Since a food store carries many items, it is likely that you are higher on some products than on others. T..

  Construct a network for the given activities

The activities that are necessary to build one of these experimental weed-harvesting machines are listed in table. Construct a network for these activities.

  The fbi is studying bribes to congressment

The FBI is studying bribes to Congressmen. A random sample of 49 bribes is selected. The mean bribe in thousands of dollars is $150 and the standard deviation of the sample is $20. Construct a 95 percent confidence interval for the population mean.

  Three approaches always result in the same conclusion

Will all three approaches always result in the same conclusion? Explain.

  What is the mean of sampling distribution of means

The average time scheduled for a doctor's visit is 25 minutes with a standard deviation of 22 minutes.  A researcher uses a sampling distribution made up of samples of size 271.  According to the Central Limit Theore, what is the mean of sampling dis..

  What sampling method is used to select your sample data

Organise your sample data in a spreadsheet as per the instructions in the Excel sheet. What sampling method is used to select your sample data

  The two selected candies are the same flavour

What is the probability that the two selected candies are the same flavour?

  Identify the instrument or instruments used to quantify

Identify the instrument or instruments used to quantify the data, the level of measurement for each instrument, and the statistics used to analyze the data.

  Quantitative analysis

What is the probability of winning a prize in an office sweep

  Relationship between perceptions of police performance

the hypothesis that there is a relationship between perceptions of police performance and area of the city for Montgomery. What might you tell the police chief?

  Given the following complete the anova table and make the

Given the following, complete the ANOVA table and make the correct inference.

  Hazard ratio and confidence interval for treatment

Correlation and the corresponding p-value - Calculate Spearman's correlation by hand - Give the hazard ratio and corresponding confidence interval for treatment

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd