GM calculation

Discussions about editing and cleaning data
Post Reply
etuser
Posts: 36
Joined: September 3rd, 2019, 5:57 am

GM calculation

Post by etuser » September 3rd, 2020, 3:17 am

Dear Sir,

When i tried to do annual geometric mean of a monthly price survey , the cumulative Gm values exceeds the numeric value limits and end up with blank or star(*), I can see the very big numbers when i write the results to a file , Is there a way like Ln transformation to reduce the numbers and return it back after.

Many thanks

aaronw
Posts: 399
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: GM calculation

Post by aaronw » September 3rd, 2020, 4:51 pm

Could you increase the length of the numeric field and rerun it?

etuser
Posts: 36
Joined: September 3rd, 2019, 5:57 am

Re: GM calculation

Post by etuser » September 3rd, 2020, 11:50 pm

I tried the maximum numeric length 15 and it exceeds that , also tried to define a variable on the global and still that also can't hold the GM figures . finally i tried to divide the price by ten thousand , this also makes zero for items sold in cents.

aaronw
Posts: 399
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: GM calculation

Post by aaronw » September 4th, 2020, 10:41 am

How many decimal places are you including?

etuser
Posts: 36
Joined: September 3rd, 2019, 5:57 am

Data Viewr 7.5

Post by etuser » October 25th, 2020, 8:37 am

Dear Sir,

After collecting data in Cspro 7.5,0 (Release Date: 2020-10-08), when i tried to open the data using Data viewer of 7.5.0 ,it opens the data and stacked. I reinstall it again it the same

aaronw
Posts: 399
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: GM calculation

Post by aaronw » October 27th, 2020, 11:58 am

You have two different dictionaries in the wild. For instance, one dictionary on the tablets and another in CSWeb.

etuser
Posts: 36
Joined: September 3rd, 2019, 5:57 am

Re: GM calculation

Post by etuser » October 27th, 2020, 12:38 pm

Dear Aaron,

Yes, you are right there was two dictionaries, but i replaced the dictionary on my Dropbox account and on the tablet with the new dictionary, this happened after data collection work started.

aaronw
Posts: 399
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: GM calculation

Post by aaronw » October 27th, 2020, 2:24 pm

You say that you updated the dictionary on Dropbox and on the tablets. I'm guessing there was some fix you wanted to make mid survey? If you have to do this in the future add the new variable to the end of a record. Never change the length of a variable or add/delete a variable from the middle of a record.

Once your data is mixed up it can be a challenge to untangle it. Here are the high-level steps you'll need to take:
  1. Create a batch edit application to separate cases using the old dictionary and the new dictionary into two data files
  2. Use the reformat data tool to format the old data to match the new data
  3. Combine the cases together using the reformat data tool or sync it to a empty server

etuser
Posts: 36
Joined: September 3rd, 2019, 5:57 am

Re: GM calculation

Post by etuser » October 27th, 2020, 7:18 pm

well noted , many thanks

Post Reply