Data Analysis of 2022 Winter Olympics Using Spreadsheets Case Study

Data Analysis of 2022 Winter Olympics Using Spreadsheets

Are you in search of the best assignment help in the UK? Look no further than Native Assignment Help. We understand the challenges you may encounter during your academic journey, which is why we're here to alleviate your burdens. Our website is user-friendly, and our customer support team is available around the clock to assist students. Let Native Assignment Help provide quality services and relieve your academic stress today! Additionally, explore our case study to understand our work comprehensively.

Assignment 2

1.0 Screenshot

Figure 1: Table of Vote Assessment of the Class

Figure 2: Table of Vote comparison of the Barbara & Clive

Figure 3: Table of The number of books that will fit on the shelf

Figure 4: Table of calculation of ascending order of the valuations

Figure 5: Table of Assessment of Market Price of 10kg apple

Figure 6: Table of Percentage

Figure 7: Table of the Selling price of Shoes

Figure 8: Table of the Selling price of Washing Machine

Figure 9: Table of Average Flower of Height

Figure 10: Table of Total Amount of Money

2. Gibbs Model of Reflection on Application of Electronic Spreadsheet to Record Data

• Description: At the start of the module, my spreadsheet aptitudes were limited. I had a fundamental understanding of building tables and penetrating data, but I struggled with exploiting formulas and processes effectively. I discovered it demanded exploiting and interpreting numerical data efficiently.
• Feelings: Initially I felt frustrated and devastated when performing with spreadsheets. I lacked conviction in my mathematical abilities and was unconvinced about which formulas to employ for exhaustive calculations (Jadhav, et al., 2019). I discovered it challenging to visualize the connection between data sets and formulas, leading to confusion and apprehension.
• Evaluation: To enhance my spreadsheet skills, I actively desired resources and tutorials online. I comprehended different formula processes such as AVERAGE, IF, and SUM information. I practised involving these functions in various scenarios, which allowed me to acquire a better knowledge of their purpose and functionality.
• Analysis: As I resumed practising and testing spreadsheets, I noticed a considerable improvement in my ability to create and exploit data. I became more skilled at operating formulas to analyze trends, execute calculations, and create charts. I also designed a better understanding of spreadsheet association and layout, which improved the clarity and significance of my data model.
• Conclusion: Through invariant practice and inquiry, my spreadsheet skills have developed considerably. I now have more confidence in assembling and using spreadsheets to register numerical data and conduct calculations. I have comprehended how to leverage different formula functions virtually and can employ them to solve difficult problems efficiently.
• Action plan: Driving onward, I plan to restart practising and developing my spreadsheet skills. I will examine more advanced procedures and components, such as macros and pivot tables, to further improve my ability to research and demonstrate numerical data (Borg, et al., 2020). Further, I will desire opportunities to involve my spreadsheet aptitudes in real-life scenarios to strengthen my learning.

3.0 Analysis of Spreadsheet

3.1 Finding & Analysis of the first missing value

To discover the missing value of the "gold medals column", here use "Excel" to discover the average value of the "remaining value in the column" value in the “column of gold medals”. To discover the average value of the "remaining value in the column gold medals" here is the Excel formula i.e. Average (total gold values) which is contained in Cell C4:C13.

a) Average of "remaining value in the column" Gold Medal

8.56

Table 1: Table of Average of Gold Medal of "remaining value in the column" Top 10 NOCs

After putting the average value formula in an Excel spreadsheet to discover the "remaining value in the column" values in the "gold medals" the answer to the average value becomes 8.56. 

3.2 Finding & Analysis of the Second missing value

Figure 12: "Beijing" 2022 Winter Olympic Table of Medals (Top 10 Countries) & Formula of "median" of Silver Medal of "remaining value in the column"

To discover the missing value of the silver medal column, here use "Excel" to discover the "median" value of the "remaining value in the column" value in the column of “silver medals” (Chen, et al., 2021). To discover the "median" value of the "remaining value in the column" "silver medals" here puts the Excel formula i.e. "median" (total silver values) which is contained in Cell D4:D13.

b) "median" of "remaining value in the column" Silver Medal

7

Table 2: Table of "median" of Silver Medal of "remaining value in the column" Top 10 NOCs

After putting the "median" value formula in an Excel spreadsheet to discover the "remaining value in the column" values in the "silver medals" the answer to the "median" value becomes 7.0.

3.3 Finding & Analysis of the Third Missing Value

To discover the missing value of the bronze medal column, here use "Excel" to discover the "minimum" value of the "remaining value in the column" value in the column of “bronze medals"”. To discover the "minimum" value of the "remaining value in the column" bronze (Dauda, et al., 2021) medals here put the Excel formula i.e. min (total bronze values) which is contained in Cell E4:E13.

c) "minimum" Value of "remaining value in the column" Bronze Medal

2

Table 3: Table of "minimum" value of Bronze Medal of "remaining value in the column" Top 10 NOCs

After putting the "minimum" value formula in an Excel spreadsheet to discover the "remaining value in the column" values in the "bronze medals" the answer to the "minimum" value become 2.0.

3.4 Finding & Analysis of the Fourth Missing Value 

Figure 14: "Beijing" 2022 Winter Olympic Table of Medals (Top 10 Countries) & Formula of Sum of Each Medal of Norway

To discover the missing value of the "sum of the number of each medal type awarded to Norway", here use "Excel" to discover "the sum of the number of each medal". To discover "the sum of the number of each medal" value here puts the Excel formula i.e. sum (total medals values) which is contained in Cell C4:E4.

d) Sum of Each Medal of Norway

37

Table 4: Table of Sum value of Each Medal of Norway

After putting the formula of the "sum of the number of each medal type awarded to Norway", the answer to "the sum of the number of each medal" type value become 37.0.

3.5 Reassessment of Spreadsheet

"Beijing" 2022 Winter Olympic Table of Medals (Top 10 Countries)
						Order	National Olympic Committee	Gold	Silver	Bronze	Total
1	Norway	16	8	13	37
2	Germany	12	10	5	27
3	People's Republic of China	9	4	2	15
4	United States of America	8	10	7	25
5	Sweden	8	5	5	18
6	Netherlands	8	5	4	17
7	Austria	7	7	4	18
8	Switzerland	7	2	5	14
9	ROC	6	12	14	32
10	France	5	7	2	14

Table 5: Table of Reproduced Chart of "Beijing" 2022 Winter Olympic Table of Medals

By Finding the missing value of each medal i.e. "gold medals" values, Silver Medal's values, and Bronze medal values in the table of “Winter Olympic”, here determined that the gold medal value becomes 9.0, Silver medal value becomes 7.0, and Bronze medal values become 2.0 respectively (Iozzo, et al., 2021). Also, the total value is 37.0 All the medal values are defined with separate and various formulas the gold medal value is formulated by using the average formula, the silver medal value is formulated by using the "median" formula, and the bronze medal value is formulated by using the "minimum" formula.

4.0 Assessment of spreadsheet

4.1 Illustration of Steps

To make the data level in descending order, explain the steps of that. To assess the descending order first select the data tab and then select the “z to a” order and after that select “Continue with the current selection and the sort.

Descending order Arrangement
Order	National Olympic Committee	Total	Descending Order
			Order	National Olympic Committee	Total
1	Norway	37	1	Norway	37
2	Germany	27	2	ROC	32
3	People's Republic of China	15	3	Germany	27
4	United States of America	25	4	United States of America	25
5	Sweden	18	5	Sweden	18
6	Netherlands	17	6	Austria	18
7	Austria	18	7	Netherlands	17
8	Switzerland	14	8	People's Republic of China	15
9	ROC	32	9	Switzerland	14
10	France	14	10	France	14

Table 6: Table of Descending Order Reproduced Chart of "Beijing" 2022 Winter Olympic Table of Medals

After generating the “z to a” descending order format, here the table reproduced the data level in descending mode.

4.2 Discussion of Top 10 NOCs in Medal Winnings

By sorting the data level of "Beijing" 2022 Winter Olympic Table of Medals, here discover the graph insights in the Excel spreadsheet (Kabacoff, 2022). This bar chart here determines that Norway get the highest value in order to medal-winning mode.

5.0 Assessment of Correlation

5.1 Description of Graph that Suitable to Show the Correlation between Bronze Medal & Gold Medal Winnings

A "scatter plot" would be suitable to show the correlation between bronze medal winnings & gold medal winnings in "Beijing" 2022.

5.2 Correlation Graph between Bronze Medal & Silver Medal Winnings

Through the above scatter chart, here discovers that the Bronze value remains stable in its way but the silver value fluctuates by the year quickly.

5.3 Assessment of Correlation between Bronze Medal & Gold Medal Winnings

To select the type of correlation between bronze medal winnings & gold medal winnings of the Top 10 NOCs of "Beijing" 2022, further data analysis is needed.

6.0 Survey Analysis

6.1 Consideration of Faults & Improvement of Survey

Leading Questions: If survey questions possess biased language or conduct respondents towards a detailed response, the effects may be skewed. For example, a question like, "Don't you approve that our product is the most useful on the market?" presumes a positive answer, potentially affecting respondents to react in a way that aligns with the hypothesis.

Response Options: Insufficient or limited answer choices can determine respondents' from deliver accurate solutions. If the unrestricted options do not protect the full scope of probable responses, respondents may choose an alternative that does not reflect their idea, leading to inconsistent data.

Order Bias: The order in which survey questions are offered can affect respondents' answers. For instance, if a survey starts with negative information about development or service, it may prime respondents to deliver more additional negative feedback throughout the survey, conducting to biased consequences.

Non-Exhaustive Options: If survey questions supply response choices that do not protect all possible solutions, respondents may be propelled to select an alternative that does not accurately describe their philosophy. This can be conducted with incorrect or preliminary data.

6.2 Population of Survey

The population of the survey would be the class of individuals who stay or operate the website being directed to in the survey.

6.3 Analysis of Random Sampling

Define the Population: Start by indeed defining the population of inquisitiveness. This is the level from which you want to remove your sample.

Random Selection: Utilize a random selection procedure to assure that each component of the population has an equivalent chance of being elected (Ravshanov, et al., 2020). There are several modes to accomplish this, like utilizing random number generators, random sampling software, or random number tables.

Execute the Sampling Process: Execute the chosen sampling method to pick people from the population. This could affect assigning digits to people and utilizing a random sampling method or operating specific benchmarks for clustering or stratification.

Collect Data: Once the instance is determined, collect the required data from the designated people by using suitable methods like interviews, observations, or surveys.

6.4 Advantages of Random Sampling

One advantage of using a random sample in this instance is that it enables undervaluing bias and provides that each person in the population has an equivalent chance of being determined for the survey.

6.5 Disadvantages of Random Sampling

One disadvantage of using a random sample in this instance is that it may not deliver an expected sample of specific subgroups within the population (Altay, 2020) that are underrepresented or neglected by possibility.

7.0 Assessment of statements

7.1 Statement: 1

The above figure shows the sum of all "gold medals" whose starts with “S”. The country of “Sweden” and “Switzerland” comes from “S” and their total gold medal value is calculated by using the formula i.e. Sum (total gold medal values). These "gold medals" values contain the Excel spreadsheet’s cells C6 and C9

7)a )

The sum of all the "gold medals" (Name starts with S)

Sweden+Switzerland

15

Table 7: Table of The sum of all the "gold medals" (Name starts with S)

By determining the above-mentioned formula, the total number of "gold medals" of “Sweden” and “Switzerland” becomes 15.0.

7.2 Statement: 2

The above figure shows the Average of "gold medals" in which NOC has awarded less than 10 "bronze medals". The average of "gold medals" in which NOC has awarded less than 10 "bronze medals" is calculated by using the formula i.e. average (total gold medal values). These "gold medals" values contain the Excel spreadsheet’s cells E3:E9 and E11.

7)b)

Average of "gold medals" which NOC has awarded less than 10 "bronze medals"

4.25

Table 8: Table of Average of "gold medals" which NOC has awarded less than 10 Bronze medal

By determining the above-mentioned formula, the total number of Average of "gold medals" in which NOC has awarded less than 10 "bronze medals" becomes 4.25.

7.3 Statement: 3

The above figure shows the count number of those "NOCs that have been awarded 10.0 or more silver medals". The count of the number of those "NOCs that have been awarded 10.0 or more silver medals" is calculated by using the formula i.e. sum (total gold medal values).

7)c)

NOCs that have awarded 10 or more than 10 "silver medals"

Germany, USA, ROC

3

Table 9: Table of NOCs that have awarded 10 or more than 10 "silver medals"

By determining the above-mentioned formula, the total number of count of a number of those "NOCs that have been awarded 10.0 or more silver medals" becomes 3.0.

8.0 Pie Chart Analysis

8.1 Creation of Pie Chart

The above figure shows the Pie Chart of "Beijing" 2022 Winter Olympic Table of Medals. The total medal winnings (Medium.datadriveninvestor.com, 2021) of the Top 10 NOCs at the "Beijing" 2022 Winter Olympic Games' highest medal holders are “Norway” and the lower medal holders are “France”.

8.2 Interpretation of Pie Chart

Two probable justifications for the behaviour of the data are

• Seasonal Variation: The data may indicate ways or instabilities that align with seasonal trends or cyclic practices intrinsic to the sensation being analyzed.
• External Factors: The behaviour of the data could be affected by external factors like transformations in economic circumstances, policy shifts, or different possibilities that have an immediate effect on the variables being estimated.

Overcome Economics Assignment With Native Assignment Help! Our economics gurus offer lucid thoughts on microeconomics, macroeconomics, and analysis of economic policy. Rely on Native Assignment Help for your thoroughly researched assignments that show you understand the principles of economics.

References

Journals

Rizzetto, F., Jansen, E., Strozzi, M. and Pellicano, F., 2019. Nonlinear dynamic stability of cylindrical shells under pulsating axial loading via Finite Element analysis using numerical time integration. Thin-Walled Structures, 143, p.106213.

Liu, N.N., Zhang, A., Liu, Y.L. and Li, T., 2020. Numerical analysis of the interaction of two underwater explosion bubbles using the compressible Eulerian finite-element method. Physics of Fluids, 32(4).

Jadhav, A., Pramod, D. and Ramanathan, K., 2019. Comparison of performance of data imputation methods for numeric dataset. Applied Artificial Intelligence, 33(10), pp.913-933.

Borg, M.G., Xiao, Q., Allsop, S., Incecik, A. and Peyrard, C., 2020. A numerical performance analysis of a ducted, high-solidity tidal turbine. Renewable Energy, 159, pp.663-682.

Chen, Z., Chen, W., Smiley, C., Shah, S., Borova, I., Langdon, D., Moussa, R., Beane, M., Huang, T.H., Routledge, B. and Wang, W.Y., 2021. Finqa: A dataset of numerical reasoning over financial data. arXiv preprint arXiv:2109.00122.

Dauda, J.A., Silva, L.C., Lourenço, P.B. and Iuorio, O., 2021. Out-of-plane loaded masonry walls retrofitted with oriented strand boards: Numerical analysis and influencing parameters. Engineering Structures, 243, p.112683.

Iozzo, D.A., Khera, N., Stein, L.C., Mitman, K., Boyle, M., Deppe, N., Hébert, F., Kidder, L.E., Moxon, J., Pfeiffer, H.P. and Scheel, M.A., 2021. Comparing remnant properties from horizon data and asymptotic data in numerical relativity. Physical Review D, 103(12), p.124029.

Kabacoff, R., 2022. R in Action: Data Analysis and Graphics with R and Tidyverse. Simon and Schuster.

Ravshanov, N., Muradov, F. and Akhmedov, D., 2020. Operator splitting method for numerical solving the atmospheric pollutant dispersion problem. In Journal of Physics: Conference Series (Vol. 1441, No. 1, p. 012164). IOP Publishing.

Article

Altay, (2020) Performance analysis of multi-objective artificial intelligence optimization algorithms in numerical association rule mining Available at link.springer.com/article/10.1007/s12652-019-01540-7 [Accessed on: 19.5.2023]