Are the top and bottom the same plant? It doesn't look dead quite yet, but if you keep it in the same conditions, I am confident it will be dead in no time. If you want your palm to do well, try outside for a change (assuming you didn't just bring it inside for the picture). That soil also looks a bit iffy; I think it would like new soil (possibly a better mix?). As Andy said, if it is outside, and you let the rain water it (granted it has good drainage), I think it will do fine. Put it in a sunny spot, but acclimate it to avoid sunburn. Good luck! ~palmsandsnow

This appears to be Cycas revoluta, a native of southern Japan. Yes, it likes a well-drained soil and will suffer from overwatering, but it is essentially a subtropical plant. Popular as they are here in the low desert, they are not really suitable for our climate. What you have here looks like a classic case of sunburn. If the damage is not too great, it may turn green again when the weather cools and if an adjacent building's or wall's shadow reaches in the afternoon, when the sun is especially intense. Mine is in a deep pot, under an australian willow acacia tree that casts a rather thin shade, and so mine burns a little. I drench it twice a week in this hot season (but that is to accommodate its hard life in a pot). Something you might try in the short run is draping the whole plant in cheese cloth or shade cloth. Raised on bamboo canes clipped in place with clothespins may not be the prettiest sight in your garden, but it may save the plant until you can establish a new tree or dig it up and move it to a new home (against the north or east side of a wall or building, where it will get all-day bright shade or afternoon shade). If you want an almost look-alike plant that is better-suited to our climate, try a Mexican dioon, a close relative. It is in the genus Dioon, and various species range from medium green to silvery or bluish green. Even these are a bit happier with a little shade, but they aren't nearly so vulnerable to sunburn. Good luck getting this corner looking as nice as you'd like it too!

Looks like planting shock and sun damage. My queen palms were put directly into the sun, they looked like this right after as they were put into the September blazing afternoon sun. This damage cannot be fixed and will not go away until the frond dies. My queens still have this damage, but i have cut the leaf tips to make it look better. Consistant watering is a good help to get it out of shock while it gets established.

It needs to be in a east or west facing window. They like good sunlight, with it being in a north facing window, it doesnt get as much light as it would if it were in a west or east facing window. You cant really overwater a majesty, as they grow on river banks. Watering should not be a problem. Although it does need a well draining pot. It may have a fungal issue aswell. Im not much of an expert, but i can tell you that it needs to be in a different window if possible.