- This topic has 8 replies, 4 voices, and was last updated 4 months ago by
.
-
Posts
-
Is there a way to code data based on a selection in the graph window or through a function that uses boolean logic?I am trying to extract the mean of values from different parts of my raw data. I have done a kludgy work around using Set Aside but I’d like to have a new attribute (‘Angle (deg)) that would allow me to do the means and later analysis directly.BTW, I could not figure out how to paste values into multiple cells. Is that possible?Thanks for any suggestions. Regards,David L. Erhart, PhD
Hello,The Choosy builtin plugin may be of help. Notice that in the screenshot using the Tag Cases tab you can create an attribute and assign values based on selection.Does that get at least partway to solving your problem?Bill
Thanks, Bill. That worked. It’s a bit glitchy. I could only make choosy work in the table not with selections from the graph. Is that the intended functionality?Also, the graph using the grouped means did not format the same way the graph that was created from a separate table of vales did. for example, the y-axis did not have tick marks.
Can you share the dataset (CSV) or the CODAP document (by going to the hamburger menu to the left of the document title and choosing Share->Get link to shared view)?I have an idea about a way to use a formula to pick out these sections that don’t change by much compared with other sections.
Try sending to codap@concord.org.
Yes, you can code data based on a selection in the graph window or through a function using Boolean logic. Here’s a general approach that might help you:
- Using Boolean Logic for Data Selection: You can create a new attribute, such as Angle (deg), by applying Boolean logic to your raw data. For example, you could use a function like
IFto assign values based on conditions. In Excel or similar software, it might look like this:
=IF(A2 > 30, “High Angle”, “Low Angle”)
- This would categorize your data into High Angle or Low Angle based on your condition.
- Calculating the Mean: Once you’ve categorized your data, you can easily calculate the mean for each category. If you’re using Excel, you might use the
AVERAGEIFfunction:=AVERAGEIF(B2:B100, “High Angle”, C2:C100)- This will calculate the mean of the values in column C where the condition in column B (your new attribute) is “High Angle.”
- Pasting Values into Multiple Cells: If you’re trying to paste values into multiple cells at once, you can usually do this by copying the desired value, selecting the range where you want to paste, and then pasting. In Excel, you might use
Ctrl+Vor right-click and select “Paste.” If you’re dealing with formulas, make sure your cell references are set up correctly to apply the formula across multiple cells.
- If you’re using a specific software tool, the exact steps might differ slightly, but the general principles remain the same.Hope this helps!
- Using Boolean Logic for Data Selection: You can create a new attribute, such as Angle (deg), by applying Boolean logic to your raw data. For example, you could use a function like
- You must be logged in to reply to this topic.