Keith Putirka
Keith Putirka
  • 199
  • 142 631
Use a theoretical model to linearize a regression problem
This video uses data from Norman Bowen's 1913 experiments on plagioclase solid solution to show how theoretical models can be used to model data. We will apply the thermodynamic equation -RTlnK = dG to create a linear equation where the coefficients from a regression analysis have physical meaning (as opposed to an empirical model, where the coefficeints have no meaning, or at least no obvious meaning).
Переглядів: 75

Відео

Using Goal Seek in Excel (and models imported from JMP
Переглядів 846 місяців тому
This video shows how to make use of the Goal Seek tool in Excel. In the video, models that were created in JMP were typed into Excel to predict literacy rates, "Lit", when average years of education, "Ay" is used as input. What if we want to know "how many years of education will it take to reach 50% literacy? Our models were calibrated to predict Lit, not Ay, but the Goal Seek tool in Excel le...
Interpreting the ANOVA and Summary of Fit in JMP
Переглядів 1406 місяців тому
This video shows how to interpret and use the values that are reported in the "Summary of Fit", the "Analysis of Variance" (or ANOVA) and the "Parameter Estimates" boxes in JMP when you create a regression model
X-Y Fit Special in JMP
Переглядів 956 місяців тому
This video shows how to use the "fit special" menu of curve fitting options in JMP to create more complex fits, including fits that have a 0 intercept (which means that there will be no "constant" value, not necessarily that the curve will hit-the y-axis at 0)
Plot Data and models in Excel (what to do if Excel refuses to plot data)
Переглядів 666 місяців тому
Sometimes Excel will refuse to plot data, no matter how many times you ask. The only answer is to start over, unfortunately; this video illustrates the issue that you may sometimes run across
X-Y linear and quadratic models in JMP
Переглядів 2246 місяців тому
Shows how to create a linear regression model and a quadratic regression model using JMP and how to export those models to plot into Excel
Select data and row states in JMP
Переглядів 916 місяців тому
Shows how to use JMP to select data that you want to model and how to hide and/or exclude data that you don't want to focus on.
Diffusion modeling part 1
Переглядів 1217 місяців тому
This video shows how to set up a 1 dimensional, point source diffusion model in Excel
Mixing models: test using sum of squares end-member fractions
Переглядів 1317 місяців тому
This video shows a test of how well a given mixing model explains a given set of data. This is a follow up on our video on how to develop a mixing model.
(Magma) Mixing model - 2 component mixing in Excel
Переглядів 2597 місяців тому
Shows how to develop a 2-component mixing model, using mafic and felsic magma compositions from the Lassen Volcanic Center as an example
Convert oxides to elements
Переглядів 1,4 тис.Рік тому
This video complements another video ("Convert elements to oxides") and shows how to obtain the wt. % of oxygen in the process, as well as a crucial caveat to this calculations if dealing with potentially O-rich systems.
Convert Molarity to ppm
Переглядів 2,3 тис.Рік тому
Builds on prior video (see "How much of a Mineral will dissolve in Water? Fluorite Example") by showing how to convert the Molar concentration of Ca in an aqueous solution into a ppm concentration
How much of a mineral will dissolve in water? Fluorite example
Переглядів 183Рік тому
Shows how to use solubility product values (Ksp) to determine how much of a mineral will dissolve in an aqueous (H2O) solution. Uses fluorite (CaF2) as an example (K. Putirka)
Mirror Planes and Mirror Symmetry
Переглядів 3272 роки тому
Explains the concept of a mirror plane, using figures from the online text of Dexter Perkins (by Keith Putirka)
EMT Demo assessment 4-3-22
Переглядів 1972 роки тому
Demo of patient assessment for PH49 EMT Class
Convert Elements to Oxides
Переглядів 6 тис.2 роки тому
Convert Elements to Oxides
Mantle Tp 5: Thermodynamic Parameters
Переглядів 1492 роки тому
Mantle Tp 5: Thermodynamic Parameters
Mantle Tp 4: KD(Fe Mg), and How to Find a Target Fo Content
Переглядів 1732 роки тому
Mantle Tp 4: KD(Fe Mg), and How to Find a Target Fo Content
Mantle Tp I: What is Tp? (Inputs/Outputs for Mantle Tp Excel Workbook)
Переглядів 2572 роки тому
Mantle Tp I: What is Tp? (Inputs/Outputs for Mantle Tp Excel Workbook)
Mantle Tp 3: Check Heat of Fusion and Melt Fraction
Переглядів 1142 роки тому
Mantle Tp 3: Check Heat of Fusion and Melt Fraction
Mantle Tp 2: How to enter data
Переглядів 1382 роки тому
Mantle Tp 2: How to enter data
What is Mantle Potential Temperature? (What inputs are needed)
Переглядів 5042 роки тому
What is Mantle Potential Temperature? (What inputs are needed)
Diffractogram: how to calculate d-spacings from an XRD pattern
Переглядів 5533 роки тому
Diffractogram: how to calculate d-spacings from an XRD pattern
Create a plot in Excel with different series
Переглядів 1733 роки тому
Create a plot in Excel with different series
Habitable Worlds Conference 2021, Putirka and Xu
Переглядів 2553 роки тому
Habitable Worlds Conference 2021, Putirka and Xu
Phyllosilicates 4: the micas
Переглядів 4913 роки тому
Phyllosilicates 4: the micas
Phyllosilicates 2: t-o structures (kaolinite and lizardite)
Переглядів 5213 роки тому
Phyllosilicates 2: t-o structures (kaolinite and lizardite)
Phyllosilicates 1: elements of t and o layers
Переглядів 6593 роки тому
Phyllosilicates 1: elements of t and o layers
Phyllosilicates 3: t-o-t structures (talc, pyrophyllite, vermiculite)
Переглядів 7323 роки тому
Phyllosilicates 3: t-o-t structures (talc, pyrophyllite, vermiculite)
Using Excel to Create Ternary/Triangular plots
Переглядів 13 тис.3 роки тому
Using Excel to Create Ternary/Triangular plots

КОМЕНТАРІ

  • @nin1269
    @nin1269 2 місяці тому

    What are the uses of Fe 57?

    • @keithputirka
      @keithputirka 2 місяці тому

      I don't do research on Fe isotopes, so I can't say much from first-hand knowledge, but a somewhat recent paper Ni et al. (2020; Nat. Geosci., doi: 10.1038/s41561-020-0617-y) indicates that Fe-57 can be fractionated from Fe-54 so that solid Fe would have higher 57Fe/54Fe than liquid Fe.

  • @sudhajothi1612
    @sudhajothi1612 2 місяці тому

    good

  • @teriknauer-schafer
    @teriknauer-schafer 4 місяці тому

    I'm volcanic if in spirit

  • @javier090994
    @javier090994 5 місяців тому

    This channel has a great way to explain geochemistry!! thank you so much for sharing your knowledge, I want to see all the videos!!!!

    • @keithputirka
      @keithputirka 5 місяців тому

      Thank you for the very kind comment.

  • @omarhosein9329
    @omarhosein9329 5 місяців тому

    Thank you

  • @KeithHowellCrusherGuy
    @KeithHowellCrusherGuy 6 місяців тому

    Thank you, very instructive helpful.

  • @suryaprabhatpali3013
    @suryaprabhatpali3013 8 місяців тому

    Thank you so much for taking your time to spread a valuable message! <3

  • @alikavyan3129
    @alikavyan3129 9 місяців тому

    این سنگهای کمبرلیت ارزشی داره

  • @geoffgeoff143
    @geoffgeoff143 9 місяців тому

    I can picture someone pouring out 58 ounces of salt.

  • @geoffgeoff143
    @geoffgeoff143 9 місяців тому

    Be nice if you used metric totally instead of a mix.

  • @geoffgeoff143
    @geoffgeoff143 9 місяців тому

    I like the demo with a litmus paper strip. Wet the strip then dip one end in acid and the other in alkaline.

  • @geoffgeoff143
    @geoffgeoff143 9 місяців тому

    I like the demo with a litmus paper strip. Wet the strip then dip one end in acid and the other in alkaline.

  • @geoffgeoff143
    @geoffgeoff143 9 місяців тому

    What I have never understood is what causes crystalisation at the different temperatures? Water? Pressure? I'm guessing they seperate out before crystalisation?

  • @Gingerblossoms
    @Gingerblossoms 9 місяців тому

    What makes you think using blue on a black background was a good idea. Could not see without squinting.

    • @mineralogy
      @mineralogy 9 місяців тому

      Thank you for the comment. I'll keep that in mind for future recordings (and possibly re-record some of these).

  • @Ali_M0hammed
    @Ali_M0hammed 10 місяців тому

    علوم بايو القاهره تجمع هنا 😂

  • @EscapeGoat-Band
    @EscapeGoat-Band Рік тому

    Sir. You have no idea how much you helped a person educating themselves. I want to thank you for your service. You made arfvedsonite make so much sense with just the chemical formula.

  • @EscapeGoat-Band
    @EscapeGoat-Band Рік тому

    Awesome!

  • @cumberlandite56
    @cumberlandite56 Рік тому

    Hi Keith, will you tell me what the conversion factor for Fe2O3 would be? Thank you.

    • @keithputirka
      @keithputirka Рік тому

      Be sure to check my calculations but I think to convert Fe2O3 to elemental Fe, you would multiply by 0.4499055, and then the inverse of that number should be the conversion of Fe to Fe2O3

  • @nekrylovnikolai5788
    @nekrylovnikolai5788 Рік тому

    Dear Dr. Putirka, Sorry for the stupid question, but shouldn't the "G8" parameter (Fe2+/F3+) affect Rhodes's diagram? In my copy of your spreadsheet it doesn't, however, it seems logical to me and I'm just trying to find where am I wrong. Thank you for your work!

    • @keithputirka
      @keithputirka Рік тому

      This is actually an excellent question and the problem is that the cell G8 is a relict from an earlier version of the sheet. I experimented with allowing T or P to vary with Fe2+/Fe3+ (as it likely does) but the parameter was not statistically different compared to leaving it out. So the short answer is "no" it doesn't affect the models (and I need to delete it from the spreadsheet). Thank you for finding that necessary correction.

    • @keithputirka
      @keithputirka Рік тому

      It might be easiest for me to find the problem if you send me a copy of your spreadsheet via email: kputirka@csufresno.edu

  • @isilmonika
    @isilmonika Рік тому

    I get different values every time... Iterative calculations are on. I even tried the values that you use in this video. Does not give the same results :(

    • @keithputirka
      @keithputirka Рік тому

      Are you coding it yourself, or are you using the spreadsheet that is available here? : sites.google.com/mail.fresnostate.edu/keithputirka/home

    • @isilmonika
      @isilmonika Рік тому

      Sorry I didn't see your answer... I am using the spreadsheet available in your website. There is something wrong with the iterative calculations, maybe it's about my version of excel. What do you suggest for this? Thank you for all your work and thank you for sharing with us by the way, this is the most helpful.@@keithputirka

  • @windowsstriker5612
    @windowsstriker5612 Рік тому

    Perfect,need this for thesis

  • @karunakaran1969
    @karunakaran1969 Рік тому

    Hal, Nice explanation, i dont understand , where u got the first row value like sol , could expalin that row.

    • @keithputirka
      @keithputirka Рік тому

      That's a renormalization on a volatile-free basis of estimates of the Solar photosphere composition ("Sol" for short"); I believe that particular composition is the "recommended" value from Lodders et al. (2009).

  • @tiyamikemwathunga8982
    @tiyamikemwathunga8982 Рік тому

    Well explained 🙏🏾

  • @natashakare6893
    @natashakare6893 Рік тому

    This was so helpful!! Thanks☺️☺️🙏

  • @cumhurbabaoglu2585
    @cumhurbabaoglu2585 Рік тому

    Isn't the drawing c supposed to have 4 mirror planes instead of 3?

    • @keithputirka
      @keithputirka Рік тому

      Yes, you are correct. 4 m, not 3m. I thought I re-recorded and re-posted this video, but I must have re-posted the old one? Anyway, I'll post a note in the description. Thank you for pointing this out.

    • @cumhurbabaoglu2585
      @cumhurbabaoglu2585 Рік тому

      @@keithputirka You are welcome. Overall I like your videos. They are informative and cover good topics.

  • @aminadz7890
    @aminadz7890 Рік тому

    Thank you, so useful ... But, how to convert oxides to atoms percentage?

    • @keithputirka
      @keithputirka Рік тому

      In the conversion table that appears in in columns P to AA, you would use row 6 instead of row 5, so you would take oxides (which could be entered in columns B-L instead of elements) and multiply those oxides by the correction factors in row 6. Then be sure to edit the headers, so if you are performing the multiplication in columns Q to AA, then the header in cell Q9 becomes "Element, weight proportion" (instead of "Oxide, weight proportion"), and cell A9 wold be changed to "Oxide %".

    • @keithputirka
      @keithputirka Рік тому

      Hi Amina - I later realized that this video says nothing about how to deal with Oxygen. I've recorded (and will soon post) a new video to illustrate the conversion of oxides to elements, and also how to deal with O, including some caveats for systems that are possibly very O-rich. Thank your for your question. And my apologies for not thinking it through earlier.

  • @user-wm8bi1uc8p
    @user-wm8bi1uc8p Рік тому

    Great!

  • @ayamahdi5203
    @ayamahdi5203 Рік тому

    Best one explaining this

  • @rahulbarman2867
    @rahulbarman2867 Рік тому

    Thank you sir for you explanation it helped me a lot

  • @alicanaktag1829
    @alicanaktag1829 Рік тому

    Thank you so much for sharing Dr. Putirka. By the way, I guess the conversion factor of K seems to be a little bit problematic in the video.

    • @keithputirka
      @keithputirka Рік тому

      Thank you for that correction. I'll add a note to the description

  • @canadiangemstones7636
    @canadiangemstones7636 Рік тому

    Only realized just now that I need a peridotite sample. Thanks for all your awesome videos!

  • @cowboygeologist7772
    @cowboygeologist7772 Рік тому

    Great video; thanks for posting.

  • @1.4142
    @1.4142 Рік тому

    Nice handwriting

  • @pascalprevost-aubin6172
    @pascalprevost-aubin6172 Рік тому

    Thanks!

  • @aeydra
    @aeydra 2 роки тому

    Extremely clear explanation while remaining concise, well done and great help, thank you!

  • @karstgeo7290
    @karstgeo7290 2 роки тому

    Appreciate it!

  • @sethlopez8287
    @sethlopez8287 2 роки тому

    Do we balance charges before determining coordination number?

    • @mineralogy
      @mineralogy 2 роки тому

      If I understand you correctly, then yes, you want to know the charge of the element, since it affects the radius of the atom. However, be aware that there is circularity in that for a given charge, the radius does depend upon the coordination. So in a real-life problem there is a bit of guesswork to analyze the structure and see what works.

    • @sethlopez8287
      @sethlopez8287 2 роки тому

      @@mineralogy so if I’m meant to compare the radii of Al3+ & O2-, would I multiply the radii due to needing more to balance, or is that taken care of as Al3+ already has the different Radius? Sorry if my wording is difficult to understand.

    • @mineralogy
      @mineralogy 2 роки тому

      @@sethlopez8287 if you mean, "does it matter that we need two Al for every 3 O, to create Al2O3", the answer is 'no'; the numbers of atoms per formula unit (what we sometimes call the "stoichiometry") are not a part of the calculation.

  • @yannicklepaleo
    @yannicklepaleo 2 роки тому

    Thank you very much for this, really really helpfull

  • @kawtheralhamadah7506
    @kawtheralhamadah7506 2 роки тому

    Thank you 😊 your explanation is simple and understandable. 👍🏻👍🏻👍🏻

  • @shivpansotra5895
    @shivpansotra5895 2 роки тому

    1 k subscriber complete

  • @tolmanterry
    @tolmanterry 2 роки тому

    Thanks for making this! I've listened to half a dozen people try to explain this, and your explanation finally made it make sense.

  • @mohorneogi6903
    @mohorneogi6903 2 роки тому

    Polarized light vibrating E-W strikes the anisotropic mineral. Double refraction occurs. The ray splits into E- ray and O- ray During extinction...why the intensity of one ray is becoming zero? This portion is not clear for me, Sir.

  • @essehdavid8278
    @essehdavid8278 2 роки тому

    I think this is concept of sophisticated study platform

  • @essehdavid8278
    @essehdavid8278 2 роки тому

    Love exceptional study

  • @aiti_4996
    @aiti_4996 2 роки тому

    Have my exam tomorrow. This saved me . Thanks a lot

  • @claraeunoia
    @claraeunoia 2 роки тому

    thanks a lot ❤

  • @kevinbyerly7008
    @kevinbyerly7008 2 роки тому

    What's the difference between a complete solid solution and a limited solid solution?

    • @mineralogy
      @mineralogy 2 роки тому

      That's a great question and probably requires a new video, which I'll try to record soon. In brief, An-Ab is a complete solid solution because there is no limit on the amount of Ab that can dissolve into An or vice versa. But An-Or is (highly limited) since only small amounts of Or can dissolve into An and vice versa (and Ab-Or is nearly complete at high T, but increasingly limited as T decreases).

  • @luisrubalcava5249
    @luisrubalcava5249 2 роки тому

    Why does that formula works? Great video btw

    • @keithputirka
      @keithputirka 2 роки тому

      I didn't present the derivation but it's purely mathematical - a matter of using trigonometry to convert the triangular coordinates to x-y coordinates.

    • @keithputirka
      @keithputirka 2 роки тому

      This video does not show the derivation, but gives the basic idea: ua-cam.com/video/BU7v7iYO87Y/v-deo.html

    • @luisrubalcava5249
      @luisrubalcava5249 2 роки тому

      Could you explain me or give me some guidance for the derivation please? ):

    • @keithputirka
      @keithputirka 2 роки тому

      Hi Luis - I like to assign this as an extra credit to my students, so I don't want to say too much, but the trick is to pick an arbitrary point within the triangle and then try drawing triangles with sides that run parallel to the x-y axes and triangles whose sides are the lines that bisect the apices of the triangle. The ternary units give you the known lengths along those bisectors. So you want to use trig to take the known lengths of the bisectors to determine the lengths of the sides that parallel x and y. I hope that helps.

  • @gustavomirandadiazgeologia6754
    @gustavomirandadiazgeologia6754 2 роки тому

    Thanks so much Keith, your video is really useful!

  • @stanpister6832
    @stanpister6832 2 роки тому

    Hi Keith. I am doing a paper on lithium in pegmatite rocks....specifically the geological aspects of the pegmatite and its relation to Lithium deposits. Do you have any recommendations on books or websites? Can you drop a link?

    • @keithputirka
      @keithputirka 2 роки тому

      Hi Stan - I don't have a link to a specific book (it's far from my area of expertise), but anything authored by David London should work well.