Posts

Showing posts with the label excel
Image
  Excel project for the coeff of static friction (GY): Enter the acceleration or force values ​​on the Y axis obtained from the graphs of each experiment. (GZ) :  Enter the corresponding Z-axis values ​​obtained from the graphs. tangent:GY/GZ A in radians: =ATAN( ) A in degrees: =DEGREES( ) U STATIC: same value of tangent
Image
  excel2: Angles with phyphox To experimentally determine the tilt or inclination angles of an object using our smartphone sensors, the Phyphox  app is a very good tool. By utilizing the built-in accelerometer sensor, we can accurately record the gravity components across the Y -axis ( gY ) and Z -axis ( gZ) . Data Table MEASURING ANGLES : The identifier for each individual test or measurement taken. gY : The acceleration value along the Y-axis extracted from the Phyphox app. gZ : The acceleration value along the Z-axis extracted from the Phyphox app. gY/gZ : The mathematical ratio between both components. ARC TANG: The arctangent of the previous ratio (resulting in radians). ANGLE: The final calculated angle converted into sexagesimal degrees. REAL ANGLE : The actual physical angle measured with a manual protractor or analog reference tool. ERROR: The absolute difference between your calculated angle and the real reference angle. %ERROR : The percentage deviation ...
Image
 Excel First, you need to define three main values: w (frequency) which controls how fast the wave moves, ø (phase) which sets the starting point, and A (amplitude) which determines how high and low the wave goes. In my example, we used 100 , 34.4 , and 311 . ¿how to calculate? 1.For the third column multiply the frequency by time and then for the next add the phase.  2.Convert that result into radians. 3.Apply the Sine function and then multiply it by your Amplitude.