Enjoy Upto 50% OFF on Assignment Solutions!
Data Analysis of 2022 Winter Olympics Using Spreadsheets Case Study By Native Assignment Help.
Ph.D. Writers For Best Assistance
Plagiarism Free
No AI Generated Content
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.
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
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.
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.
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.
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.
"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.
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.
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.
A "scatter plot" would be suitable to show the correlation between bronze medal winnings & gold medal winnings in "Beijing" 2022.
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.
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.
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.
The population of the survey would be the class of individuals who stay or operate the website being directed to in the survey.
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.
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.
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.
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.
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.
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.
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”.
Two probable justifications for the behaviour of the data are
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]
Go Through the Best and FREE Case Studies Written by Our Academic Experts!
Native Assignment Help. (2024). Retrieved from:
https://www.nativeassignmenthelp.co.uk/data-analysis-of-2022-winter-olympics-using-spreadsheets-case-study-24758
Native Assignment Help, (2024),
https://www.nativeassignmenthelp.co.uk/data-analysis-of-2022-winter-olympics-using-spreadsheets-case-study-24758
Native Assignment Help (2024) [Online]. Retrieved from:
https://www.nativeassignmenthelp.co.uk/data-analysis-of-2022-winter-olympics-using-spreadsheets-case-study-24758
Native Assignment Help. (Native Assignment Help, 2024)
https://www.nativeassignmenthelp.co.uk/data-analysis-of-2022-winter-olympics-using-spreadsheets-case-study-24758
Unit 8: Innovation And Commercialization (Hibo) Looking for top-notch...View or download
Technology Giant Apple Shapes Future Through Strategic Innovation Are you in...View or download
Operational Management and Competitive Positioning of Popeyes Are you in...View or download
Core Principle Of Diabetes Introduction - Core Principle Of Diabetes Get...View or download
Orientation For Success In Higher Education Seeking assignment help...View or download
How BP's Leadership Drives Global Success Introduction Every Organization has...View or download
Get your doubts & queries resolved anytime, anywhere.
Receive your order within the given deadline.
Get original assignments written from scratch.
Highly-qualified writers with unmatched writing skills.
We utilize cookies to customize your experience. By remaining on our website, you accept our use of cookies. View Detail
Hi! We're here to answer your questions! Send us message, and we'll reply via WhatsApp
Please enter a messagePleae enter your phone number and we'll contact you shortly via Whatsapp
We will contact with you as soon as possible on whatsapp.
Ph.D. Writers For Best Assistance
Plagiarism Free
No AI Generated Content
offer valid for limited time only*