Forum Discussion
Excel
When expressing the level of occurrence of diseases in animals, it is determined by the percentage expression of the number of positive (diseased) results as a result of testing the number of samples taken from infected animals. For example, 30 out of 108 samples gave a positive result, so the incidence rate is 27.78%. The dashboard in the Excel program correctly represents the sum of the number of samples in the investigated areas for each year, but incorrectly shows the prevalence (%) of the disease, which is 25.62% is showing. Community members please help me in this matter.
Хўжаликларда Жами текширилган намуналар сониИжобий натижа %Общий итог28727,862
| Вилоят номи | (Все) | |
| Хўжаликлар номи | (Все) | |
| 2019 | 108 | 25,62 |
| 2020 | 53 | 27,78 |
| 2021 | 126 | 29,46 |
It sounds like you want to create a combined chart in your Excel dashboard that shows the growth rate of the disease over the years, with the number of samples and test results expressed as percentages. To achieve this, you can follow these steps:
- Data Preparation: Ensure you have the following data:
- Year (e.g., 2019, 2020, 2021)
- Total Number of Samples for each year
- Number of Positive Results for each year
- Calculate Disease Prevalence Percentage: Calculate the disease prevalence percentage for each year using the formula mentioned earlier:
\text{Prevalence (%) = (Number of Positive Results / Total Number of Samples) * 100}
You should have these prevalence percentages for each year: 2019, 2020, and 2021.
- Create a Combined Chart: To create a combined chart showing both the total number of samples and disease prevalence percentage over the years, follow these steps:
- Select your data, including the years, total number of samples, and prevalence percentages.
- Go to the "Insert" tab in Excel.
- Choose the type of chart you want to create. You can select a clustered column chart for this purpose.
- Excel will create a chart with both bars representing the total number of samples and lines representing the prevalence percentages.
- Format the Chart: You can format the chart as needed, including adding data labels to the bars and lines to display the actual values or percentages, depending on your preference.
- Label Axes and Add Titles: Make sure to label the axes (X and Y) and add titles to the chart to make it clear and informative.
- Finalize Your Dashboard: Place the chart in your Excel dashboard along with any other relevant information or charts you want to include. Ensure that your data is correctly represented, and the chart accurately reflects the growth rate of the disease over the years.
By following these steps, you should be able to create a combined chart in your Excel dashboard that effectively presents the growth rate of the disease using the number of samples and prevalence percentages. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
4 Replies
It appears that you are trying to calculate the disease prevalence percentage based on the number of positive results and the total number of samples taken each year. The formula to calculate the disease prevalence percentage is:
\text{Prevalence (%) = (Number of Positive Results / Total Number of Samples) * 100}
Let us calculate the prevalence percentages for the years 2019, 2020, and 2021 based on the provided data:
- For 2019:
- Number of Positive Results (2019): 30
- Total Number of Samples (2019): 108
- Prevalence (%) = (30 / 108) * 100 = 27.78% (as you correctly mentioned)
- For 2020:
- Number of Positive Results (2020): Not provided
- Total Number of Samples (2020): 53
- Prevalence (%) = (Number of Positive Results / 53) * 100 (you need to provide the number of positive results for 2020 to calculate this)
- For 2021:
- Number of Positive Results (2021): Not provided
- Total Number of Samples (2021): 126
- Prevalence (%) = (Number of Positive Results / 126) * 100 (you need to provide the number of positive results for 2021 to calculate this)
Make sure you have the accurate number of positive results for the years 2020 and 2021, and then use the formula to calculate the prevalence percentages for those years. If you have the correct data, you should be able to calculate the prevalence correctly in Excel.
The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
Dear Nicolino!!! Thank you for taking the time to answer my question. I hope I can solve this problem with your help. I wanted to present my data using a combined chart in the Dashboard showing the growth rate of the disease over the years by expressing the number of samples and test results as a percentage. Maybe I'm choosing the wrong format in the cell that represents the sum of the data, which is causing this error.
I would be very grateful if you could help me with this matter.
It sounds like you want to create a combined chart in your Excel dashboard that shows the growth rate of the disease over the years, with the number of samples and test results expressed as percentages. To achieve this, you can follow these steps:
- Data Preparation: Ensure you have the following data:
- Year (e.g., 2019, 2020, 2021)
- Total Number of Samples for each year
- Number of Positive Results for each year
- Calculate Disease Prevalence Percentage: Calculate the disease prevalence percentage for each year using the formula mentioned earlier:
\text{Prevalence (%) = (Number of Positive Results / Total Number of Samples) * 100}
You should have these prevalence percentages for each year: 2019, 2020, and 2021.
- Create a Combined Chart: To create a combined chart showing both the total number of samples and disease prevalence percentage over the years, follow these steps:
- Select your data, including the years, total number of samples, and prevalence percentages.
- Go to the "Insert" tab in Excel.
- Choose the type of chart you want to create. You can select a clustered column chart for this purpose.
- Excel will create a chart with both bars representing the total number of samples and lines representing the prevalence percentages.
- Format the Chart: You can format the chart as needed, including adding data labels to the bars and lines to display the actual values or percentages, depending on your preference.
- Label Axes and Add Titles: Make sure to label the axes (X and Y) and add titles to the chart to make it clear and informative.
- Finalize Your Dashboard: Place the chart in your Excel dashboard along with any other relevant information or charts you want to include. Ensure that your data is correctly represented, and the chart accurately reflects the growth rate of the disease over the years.
By following these steps, you should be able to create a combined chart in your Excel dashboard that effectively presents the growth rate of the disease using the number of samples and prevalence percentages. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
- Dear Nicolino!!! Thank you for taking the time to answer my question. I hope I can solve this problem with your help. I wanted to present my data using a combined chart in the Dashboard showing the growth rate of the disease over the years by expressing the number of samples and test results as a percentage. Maybe I'm choosing the wrong format in the cell that represents the sum of the data, which is causing this error.
I would be very grateful if you could help me with this matter.
