excel assignment

  Using the McGraw-Hill Dataset in the Excel file, , complete the following tasks: Task#1: Compute the mean number of home runs per game. To do this, first find the mean number of home runs per team. Next, divide this value by 162 (a season comprises 162 games); then multiply by 2 because there are … Read more

Descriptive Statistics

Assignment Content CompetencyDescribe the data using the measures of central tendency and measures of variability. Student Success CriteriaView the grading rubric for this deliverable by selecting the This item is graded with a rubric link, which is located in the Details & Information pane. InstructionsScenario (information repeated for deliverable 01, 03, and 04) A major … Read more

Descriptive Statistics

Assignment Content CompetencyDescribe the data using the measures of central tendency and measures of variability. Student Success CriteriaView the grading rubric for this deliverable by selecting the This item is graded with a rubric link, which is located in the Details & Information pane. InstructionsScenario (information repeated for deliverable 01, 03, and 04) A major … Read more

Multiple Regression Analysis

Amazon.com has become one of the most successful online merchants. Two measures of its success are sales and net income/loss figures. The data can be found in the file, . Use Excel to complete the following: Construct a scatter plot for Amazon’s net income/loss and sales figures for the period 19952015.   Determine a polynomial model, … Read more

Central Tendency statistics

Statistics Number of  time out to drive in a month  N100 Mean130.1400 Median131.0000 Mode150.00 Std. Deviation28.70330 Skewness.006 Std. Error of Skewness.241 Range140.00 Number of  time out to drive in a month FrequencyPercentValid PercentCumulative Percent Valid 58.001          1.0              1.0                       1.0                                   80.001           1.0      1.0                    2.0 81.001            1.0               1.0                       3.0  82.001            1.0        1.0                      4.0 85.001             1.0 … Read more

Homework Assignment 4

Chapter 10 Case Study – Five Guys, Question #1. You will need to submit your supporting formula work and analysis/conclusions in Excel. Chapter 11 Case Study – Clarkson, Question, #2. You will need to submit your supporting formula work analysis/conclusions in Excel. Refer back to your dataset used in Module 3 homework problems. Now, let’s … Read more

Discussion Question 4

Revisit your hypotheses to see if a t-test or ANOVA would be appropriate to test your data (this will depend on your type of data; not all tests are appropriate to all types of variables). Specify your variables and data of levels. How do you determine the level of significance or p-value you will use … Read more

Data Forecasting

I need help with Excel Data Forecasting.  I need to forecast the months for the location areas listed in yellow using the 2019, 2020, and 2021 historical data, which is attached. Using the census location to project 2022 for each month listed in yellow.  I tried to do a small forecasting in excel, but only … Read more

wk 6 assignment

  Also, review the t test scenarios found in this weeks Learning Resources and consider the three different approaches of t tests: Independent sample t test Paired sample t test One sample t test Based on each of the three research scenarios provided, open the High School Longitudinal Study dataset or the Afrobarometer dataset from … Read more

Econ 1035 Report

  Given a data set that replicates the industry/world, students will be required to perform a wide range of statistical analysis covered in the course, with focus on the analysis of relationships between variables. The response to the assignment must be provided in the form of a business report with no more than 10 pages … Read more