MTH154Project2Soccer-1

.xlsx

School

Northern Virginia Community College *

*We aren’t endorsed by this school

Course

154

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

6

Uploaded by DukeAtom12025

Report
Soccer Use a cell reference or a single formula where appropriate in order to receive full credit. 2018 World Cup Goals Scored Data Set 0 1 2 3 4 5 6 0 1 2 3 4 5 0 1 2 3 a.) 0 1 2 3 MEAN MEDIAN MODE 0 1 2 3 0 1 2 3 0 1 2 3 0 1 2 3 0 1 2 3 0 1 2 3 b.) 0 1 2 The total number of data 0 1 2 The most goals scored in any g 0 1 2 The data values are an average d 0 1 2 from 0 1 2 The most common number o 0 1 2 0 1 2 c.) 0 1 2 Goals Frequency 0 1 2 0 0 1 2 1 0 1 2 2 0 1 2 3 0 1 2 4 0 1 2 5 0 1 2 6 0 1 2 0 1 2 d.) 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 1 2 1 2 1 Relative Frequency
1 1 1 1 1 1 1 1 1 e.) f.) I completed this without any help: Yes or No?
Fall/2023 STDEV.S MAX MIN RANGE COUNT a values is: game was: distance of: m the value: of goals is: a.) The cell range A5:G49 has been named Compute the descriptive statistics of the d STDEV.S for the sample standard deviation mean and standard deviation to 2 decima Format all others to 0 decimal places. b.) Fill in the blanks of the sentences. Use formulas to link to the cells with the answers in part (a). c.) Fill in the Frequency and Relative Frequency table. Use the COUNTIF fun Format relative frequencies as percentages to 1 decimal place. d.) Create a Frequency Bar Graph for data chart). Insert data labels on the outside e axis and chart titles should be chosen fro a. Goals Scored b. Frequency c. Relative Frequency d. Number of Scoring Goals e. Percentage of Scoring Goals
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help