Please, What best method can be used to represent such data?

More Difo Voukang Harouna's questions See All

Kindly Need Statistical Advises on multistage stratified sampling?

I have recently collected data on a study area divided into three sites and each site was divided into four categories and each category was subdivided into 5 transects. Each transects were also...

01 August 2019 921 7 View

Collapsology! Have you heard about?

Dear Scientists, I had recently come across the new science (to me) known as collapsology. Promoted by a group of scientists and people who beleive on the soon coming of the end of the world- just...

01 January 1970 9,427 27 View

How to compare two groups with only two measurements?

Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...

03 March 2021 8,796 3 View

Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence?

I am on the lookout for the Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence. Does anyone know where I can find it? Thank you in advance

03 March 2021 3,568 1 View

What kind of fluid could I use for a pitfall trap that also does not invalidate molecular testing?

Hi, I want to start testing pitfall trap to obtain ants samples, but I need to conduct molecular analysis on those insects. So, what kind of fluid can I use? Ethanol expires too early and I need...

03 March 2021 5,978 5 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

Do we need to write protocol for a second study of a systematic review that has been registered and published?

I have conducted and published a systematic review and meta-analysis research with the topic related to public health and health pomotion (protocol was registed in PROSPERO). Now we want to...

03 March 2021 8,920 3 View

How to increase a model accuracy ?

dear community, my model is based feature extraction from non stationary signals using discrete Wavelet Transform and then using statistical features then machine learning classifiers in order to...

03 March 2021 6,994 5 View

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature)?

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature-based reflection)? Thank you for your time and for...

03 March 2021 2,870 3 View

What degree of missing data in a particular case/participant results in Expectation-Maximisation no longer working?

I'm dealing with a mediation model and am using the PROCESS module in SPSS. Due to SPSS and PROCESS being limited in the imputation methods - being unable to handle multiple imputation - the other...

02 March 2021 4,362 1 View

Do I need to do linear regression before running mediation analysis using PROCESS MACRO by Hayes ?

I just wanted to check if I need to run a linear regression separately if I am using PROCESS MACRO to run mediation analysis. Thank you.

02 March 2021 4,359 3 View

No title

02 March 2021 3,060 3 View

G.M. Monirul Alam

Please try to find out paper on similar work then it will be very easy for you.

Difo Voukang Harouna

Dear Monirul Alam,

Thank you for your suggestion. However, couldn't get a similar article handling this. Please, can you suggest some?

Regards!

Samyadeep Ghosh

Hi,

What you might want to do is to get the frequency of each of the 10 crops in your population, a simple pivot table in excel will do that, then just plot them as barchart, crop types in x axis and frequency in y-axis. The frequency can also be converted to % by dividing it by 50 (total number of farmers).

Dear Samyadeep,

Thank you for this suggestion. I will try to extract the data in excel and try that! My only worry is that the percentage is represented as A/500 x 100 instead of A/50x100. So i thought there could be a better way of presenting such data.

Thanks!

Regards

Beckline Mukete

Dear Difo,

There were 160 crops and 50 farmers where, each farmer performed a random selection of 10 crops. To represent the selection of each crop in terms of total number of farmers (50), you need a frequency distribution table.

You have to first draw a table and set the 160 crops against the 50 farmers. From the table, you will obtain the number of farmers per crop for each of the 160 crops.You will observe a variability in farmer distribution per crop, use excel to plot your chart or graph.

Goodluck!

Anup Kumar Yadava

You can choose spike graph by setting max Y axis at 160 & you'll find better result.

Prefer Eviews software & and if any problem in handling watch spike charts in eviews videos on YouTube.

All the best!

Dear Yadava,

Thank you very much for your suggestion.

I shall try it and get back to you immediately. However, please is the Spike graph OR Eviews Softwares free online?

Thank you very much

Eviews is not a free software, but if you want spike graph you can compute it by R-Studio which is a free software,

There are some other free softwares but I am not sure that they draw spike or not.

Free software like - gretL, Matrixer.

Thank you again! Please, do you think, Can SPSS compute the spike graph? Otherwise, I am going to try R-Studio or the others proposed.

SPSS don't have spike option.

You can download Eviews student version free for a year in your system.

Thanks a lot!!

Sorry, I wish to disturb you again a little bit

I am Finding the idea of Spike chart very interesting for these data. However, I am not able to get good details about it from the net or even youtube. have just read a bit about it and it sound very interesting. Please, could you send me some links and/OR some example of plots.

From the little a read, I am thinking of applying it this way and I find it very fantastic: Since i have 10 crops selected by each farmer and each farmer can have the same selection with another farmer on a total of 50 farmers, I can set a medium line or reference line to be 25 (i.e 50farmers/2) and this will mean that all crops that appears above the value 25 have been selected at least by half of the total number of farmers. I find this very nice. Please, Is this what you also have in mind while recommending spike plot. If not I plead for more intersting detail to ease my understanding!!

Thank you very much again,

Looking forward to hearing from you

have a look at this link, I hope you will get what you need

http://www.eviews.com/Learning/graphs.html