Need help on radial distribution on excel

[Amy Chau]

Need help on radial distribution on excel!

I'm trying to create an excel spreadsheet that plots radial distribution functions for the 3s orbital of hydrogen for values of p=0...15 I have no idea where to begin

 

[Gokul43201]

What is the expression for the radial part ? Answering that, would be where you begin.

 

[ravenprp]

.

Hi there,

Creating radial distribution functions for the 3s orbital of hydrogen can seem daunting at first, but with some guidance, it can be done easily in Excel. Here are the steps you can follow to create your spreadsheet:

1. Start by creating a column for the values of p from 0 to 15. Label this column as "p" and enter the values in ascending order.

2. In the next column, label it as "r" and enter the values of distance from the nucleus for each p value. You can use the equation r = n^2a0, where n is the principal quantum number (in this case, it is 3) and a0 is the Bohr radius (0.529 Å).

3. Now, in the next column, label it as "r^2" and calculate the square of each value in the "r" column.

4. Next, create a column for the radial distribution function, labeled as "R(r)". In this column, you will use the equation R(r) = 4πr^2Ψ^2, where Ψ is the wave function. For the 3s orbital of hydrogen, the wave function is Ψ = 1/√(πa0^3) * (2 - r/a0) * e^(-r/2a0).

5. Use the "r^2" column and the wave function equation to calculate the values for the radial distribution function in the "R(r)" column.

6. Finally, select the "p" and "R(r)" columns and create a scatter plot using the "Insert" tab in Excel. This will give you a graph of the radial distribution function for the 3s orbital of hydrogen.

I hope this helps you get started on creating your radial distribution function spreadsheet in Excel. If you need further assistance, feel free to reach out for more help. Best of luck!